Re: Getting Default Values Out of MySQL

2009-12-12 Thread Carsten Haese
Victor Subervi wrote: > > > On Sat, Dec 12, 2009 at 10:54 AM, Carsten Haese > wrote: > > Victor Subervi wrote: > > Hi; > > I'm using MySQLdb. If I do a > > cursor.execute('describe myTable;') > > it gives me all sorts of data but not my defaul

Re: Getting Default Values Out of MySQL

2009-12-12 Thread Victor Subervi
On Sat, Dec 12, 2009 at 11:38 AM, MRAB wrote: > That's strange, I count 6! > > For example, the first field has the following columns: > >1. 'ID' > >2. 'tinyint(5) unsigned' > >3. 'NO' > >4. 'PRI' > >5. None > >6. 'auto_increment' Dunno why I counted 4 last time. Maybe c

Re: Getting Default Values Out of MySQL

2009-12-12 Thread MRAB
Victor Subervi wrote: On Sat, Dec 12, 2009 at 10:54 AM, Carsten Haese > wrote: Victor Subervi wrote: > Hi; > I'm using MySQLdb. If I do a > cursor.execute('describe myTable;') > it gives me all sorts of data but not my default values.

Re: Getting Default Values Out of MySQL

2009-12-12 Thread Victor Subervi
On Sat, Dec 12, 2009 at 10:54 AM, Carsten Haese wrote: > Victor Subervi wrote: > > Hi; > > I'm using MySQLdb. If I do a > > cursor.execute('describe myTable;') > > it gives me all sorts of data but not my default values. > > That function call doesn't "give" any data at all, except for the > rowco

Re: Getting Default Values Out of MySQL

2009-12-12 Thread Carsten Haese
Victor Subervi wrote: > Hi; > I'm using MySQLdb. If I do a > cursor.execute('describe myTable;') > it gives me all sorts of data but not my default values. That function call doesn't "give" any data at all, except for the rowcount (which would be the number of columns in the table). You must use s

Getting Default Values Out of MySQL

2009-12-12 Thread Victor Subervi
Hi; I'm using MySQLdb. If I do a cursor.execute('describe myTable;') it gives me all sorts of data but not my default values. How do I retrieve them? TIA, Victor -- http://mail.python.org/mailman/listinfo/python-list