Retrieving possible list for use in a subsequent INSERT

[Nick the Gr33k]

Στις 1/11/2013 12:24 πμ, ο/η Nick the Gr33k έγραψε:
> Στις 31/10/2013 9:22 μμ, ο/η rurpy at yahoo.com έγραψε:
>>
>> You set the value of 'downloads' to a list:
>>>     downloads = []
>>>     if data:
>>>         for torrent in data:
>>>             downloads.append( torrent )
>> and when you use 'downloads', use have:
>>
>>    INSERT INTO visitors (..., downloads) VALUES (..., %s), (...,
>> downloads)
>>
>> If the 'downloads' column in table 'visitors' is a
>> normal scalar value (text string or such) then perhaps
>> you can't insert a value that is a list into it?  And
>> that may be causing your problem?
>>
>> If that is in fact the problem (I am only guessing), you
>> could convert 'downloads' to a single string for insertion
>> into your database with something like,
>>
>>    downloads = ', '.join( downloads )
>
> create table visitors
> (
>    counterID integer(5) not null,
>    host varchar(50) not null,
>    refs varchar(25) not null,
>    city varchar(20) not null,
>    userOS varchar(10) not null,
>    browser varchar(10) not null,
>    hits integer(5) not null default 1,
>    visits datetime not null,
>    downloads set('Καμία Ακόμη'),
>    foreign key (counterID) references counters(ID),
>    unique index (visits)
>   )ENGINE = MYISAM;
>
> Decided to declare downlods as  SET column type.
> and maintain this:
>
>          downloads = []
>          if data:
>              for torrent in data:
>                  downloads.append( torrent )
>
>
> but error still is:
>
> [Thu Oct 31 22:24:41 2013] [error] [client 46.198.103.93]
> pymysql.err.InternalError: (1241, 'Operand should contain 1 column(s)')


Rurpy can you help me please solve this?
is enum or set column types what needed here as proper columns to store 
'download' list?