Retrieving possible list for use in a subsequent INSERT

[Nick the Gr33k]

Στις 2/11/2013 4:00 πμ, ο/η rurpy at yahoo.com έγραψε:
> On Friday, November 1, 2013 9:04:08 AM UTC-6, Ferrous Cranus wrote:
>> Rurpy can you help me please solve this?
>> is enum or set column types what needed here as proper columns to store
>> 'download' list?
>
> I'd help if I could but I don't use MySql and don't know anything
> about its column types.  All I could do it try to read about it
> (which I don't have time for right now) and you know more about
> it than me so you can probably figure it out more quickly.
>


Okey here is some improvement:

Splitting the statement in 3 steps to print it before actually executing iy.

=====
sql = '''INSERT INTO visitors (counterID, refs, host, city, useros, 
browser, visits, downloads) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)''' % 
(cID, refs, host, city, useros, browser, visits, downloads)
print repr(sql)
cur.execute(sql)
=====

This the real time values trying to be passed into MySQL table in python 
script's runtime

=====
"INSERT INTO visitors (counterID, refs, host, city, useros, browser, 
visits, downloads) VALUES (1, Χωρίς Referrer - Άμεσο Hit, 
46-198-103-93.adsl.cyta.gr, Europe/Athens, Windows, Chrome, 13-11-02 
10:31:29, [('Jobs.2013. WEBRip XViD juggs',), 
('Pacific.Rim.2013.720p.BDRip.XviD.AC3-ELiTE',), ('Man of Steel 2013 
BRRip XviD AC3-SANTi',), ('Now You See Me EXTENDED 2013 BRRip XviD 
AC3-SANTi',), ('DAS EXPERIMENT (2001) 720p.BDRip.XVID.AC3',), ('Behind 
the Candelabra 2013 BDrip XviD AC3',), 
('The.Internship.2013.UNRATED.480p.BRRip.Xvid.AC3',), ('Man Of Tai 2013 
WEBrip XVID AC3',), ('Star Trek Into Darkness 2013 BRRip XviD 
AC3-SANTi',), ('ESCAPE PLAN (2013) CAM XViD UNiQUE',)])"

ProgrammingError(ProgrammingError(1064, "You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near 'Referrer - Άμεσο Hit, 
46-198-103-93.adsl.cyta.gr, Europe/Athens, Windows, C' at line 1"),)
=====

The definition of 'visitro's table is as follows:

=====
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,
   download text not null,
   foreign key (counterID) references counters(ID),
   unique index (visits)
  )ENGINE = MYISAM;
=====

It is possible to "just" use a VARCHAR or TEXT field and then add 
anything you want to it, including a comma or semi-colon separated list.