Re: [Tutor] Creating MySQL table

2005-07-18 Thread Don Parris
On 7/18/05, Bernard Lebel <[EMAIL PROTECTED]> wrote: > See [Bernard] > > > [Bernard] Well I kind of figured it was telling it's a syntax error. ;-) > I didn't want to assume too much. ;) > After trial and error for an hour or two, I managed to get it sorted. > > First, I noticed that in Pytho

Re: [Tutor] Creating MySQL table

2005-07-18 Thread Don Parris
On 7/18/05, Bernard Lebel <[EMAIL PROTECTED]> wrote: > Hello, > > How do I create a MySQL table in Python? > > Here is what I'm trying: > > > import MySQLdb as sql > > def connect2db(): > return sql.connect( blah blah blah ) > > > oConnection = connect2db() > oCursor = oConnection.curs

Re: [Tutor] Creating MySQL table

2005-07-18 Thread Bernard Lebel
See [Bernard] On 7/18/05, Don Parris <[EMAIL PROTECTED]> wrote: > On 7/18/05, Bernard Lebel <[EMAIL PROTECTED]> wrote: > > Hello, > > > > How do I create a MySQL table in Python? > > > > Here is what I'm trying: > > > > > > import MySQLdb as sql > > > > def connect2db(): > > return sql.conne

[Tutor] Creating MySQL table

2005-07-18 Thread Bernard Lebel
Hello, How do I create a MySQL table in Python? Here is what I'm trying: import MySQLdb as sql def connect2db(): return sql.connect( blah blah blah ) oConnection = connect2db() oCursor = oConnection.cursor() sQuery = "CREATE TABLE '3DPipeline'.'TB_MT_NAME' (;\ 'ID' INTEGER UNSIGNED

Re: [Tutor] Creating MySQL table

2005-07-18 Thread Don Parris
On 7/18/05, Bernard Lebel <[EMAIL PROTECTED]> wrote: > Hello, > > How do I create a MySQL table in Python? > > Here is what I'm trying: > > > import MySQLdb as sql > > def connect2db(): > return sql.connect( blah blah blah ) > > > oConnection = connect2db() > oCursor = oConnection.curs