Victor Subervi wrote:
On Sat, Dec 12, 2009 at 10:54 AM, Carsten Haese <carsten.ha...@gmail.com
<mailto:carsten.ha...@gmail.com>> 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
rowcount (which would be the number of columns in the table).
Really?
cursor.execute('describe %s;' % store)
storeDescription = cursor.fetchall()
print storeDescription
Prints out this:
(('ID', 'tinyint(5) unsigned', 'NO', 'PRI', None, 'auto_increment'),
('SKU', 'varchar(40)', 'NO', 'UNI', None, ''), ('Category',
'varchar(40)', 'YES', '', None, ''), ('Name', 'varchar(50)', 'NO', '',
None, ''), ('Title', 'varchar(100)', 'NO', '', None, ''),
('Description', 'mediumtext', 'NO', '', None, ''), ('Price',
'float(8,2)', 'YES', '', None, ''), ('SortFactor', 'int(4)', 'YES', '',
'500', ''), ('Availability', 'tinyint(1)', 'NO', '', None, ''),
('ShipFlatFee', 'float(5,2)', 'NO', '', '10.00', ''),
('ShipPercentPrice', 'tinyint(2) unsigned', 'NO', '', '5', ''),
('ShipPercentWeight', 'tinyint(2) unsigned', 'NO', '', '2', ''),
('Associations', 'varchar(40)', 'NO', '', None, ''), ('TempPrice',
'float(7,2)', 'NO', '', None, ''), ('LastDatePrice', 'date', 'NO', '',
None, ''), ('Weight', 'float(7,2)', 'NO', '', None, ''), ('Metal',
"enum('14k gold','18k gold','white
gold','silver','tungsten','titanium')", 'NO', '', None, ''),
('PercentMetal', 'tinyint(2) unsigned', 'NO', '', None, ''), ('pic1',
'blob', 'YES', '', None, ''), ('pic2', 'blob', 'YES', '', None, ''),
('sizes',
"set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge')",
'YES', '', None, ''), ('colorsShadesNumbersShort',
"set('blue:333399','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:0000FF','yellow:9ACD32','teal:E2725B','olive:6B8E23','green:00A550','white:0F4D92','silver:708090','red:FE2712','lime:32CD32')",
'YES', '', None, ''))
In my version of MySQL, he default value is in the fifth column of the
result set.
Nice. As you can see, I only get 4 columns by default. How do I get the
fifth?
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'
--
http://mail.python.org/mailman/listinfo/python-list
