Re: MySQLdb syntax issues - HELP

2007-12-17 Thread Bruno Desthuilliers
Luke a écrit : > Bruno Desthuilliers wrote: > > >>Luke a écrit : > > (snip) > >>>cursor.execute(""" >>>CREATE TABLE %s >>>( >>> name CHAR(40), >>> gender CHAR(40), >>> job CHAR(40), >>> levelTEXT, >>> str TEXT,

Re: MySQLdb syntax issues - HELP

2007-12-17 Thread John Nagle
Luke wrote: > Bruno Desthuilliers wrote: > >> Luke a écrit : > (snip) >>> cursor.execute(""" >>> CREATE TABLE %s >>> ( >>> name CHAR(40), >>> gender CHAR(40), >>> job CHAR(40), >>> levelTEXT, >>> str TEXT, >>>

Re: MySQLdb syntax issues - HELP

2007-12-16 Thread John Nagle
Bruno Desthuilliers wrote: > Luke a écrit : >> Im very new to SQL in general, let alone coding it into python. I can >> interact with a MySQL database just fine for the most part, but im >> running >> into some problems here... > (snip) OK. Bruno has pointed out why you're having trouble w

Re: MySQLdb syntax issues - HELP

2007-12-16 Thread Gabriel Genellina
On 16 dic, 17:48, Luke <[EMAIL PROTECTED]> wrote: > Bruno Desthuilliers wrote: >> Err... Are you sure you want a new table here ? > > yes, thats the easier way i can think of for now since i am so new to SQL, > eventually im sure i will put all the characters into one larger table > though... but

Re: MySQLdb syntax issues - HELP

2007-12-16 Thread John Machin
On Dec 17, 7:48 am, Luke <[EMAIL PROTECTED]> wrote: > Bruno Desthuilliers wrote: > > Luke a écrit : > (snip) > >> cursor.execute(""" > >> CREATE TABLE %s > >> ( > >> name CHAR(40), [snip] > >> luc TEXT > >> ) > >> """ % CharAccount) > > >

Re: MySQLdb syntax issues - HELP

2007-12-16 Thread Luke
Bruno Desthuilliers wrote: > Luke a écrit : (snip) >> cursor.execute(""" >> CREATE TABLE %s >> ( >> name CHAR(40), >> gender CHAR(40), >> job CHAR(40), >> levelTEXT, >> str TEXT, >> dex TEXT, >>

Re: MySQLdb syntax issues - HELP

2007-12-16 Thread wes
Luke wrote: > Im very new to SQL in general, let alone coding it into python. I can > interact with a MySQL database just fine for the most part, but im running > into some problems here... This is the function in my script that keeps > raising errors: > > -

Re: MySQLdb syntax issues - HELP

2007-12-16 Thread Bruno Desthuilliers
Luke a écrit : > Im very new to SQL in general, let alone coding it into python. I can > interact with a MySQL database just fine for the most part, but im running > into some problems here... (snip) > > - > > def NewChar(): > """ NewChar() - >