MySQLdb integer question
Ansgar Wollnik
wiseworld at web.de
Sun Oct 19 15:11:28 EDT 2003
Polerio Babao Jr.II wrote:
>>I use Python with MySQLdb to transfer data from one database to another.
>>When I SELECT the data from the first table, numbers are provided with
>>an 'L' at the end to show, they are treated as a Long Integer (see:
>>http://www.esrf.fr/computing/bliss/python2/MySQL/MySQLdb-3.html#ss3.4).
>>
>>Now I want to put that data into the new database but the 'L's are still
>>there. What can I do?
>>>>c = ('a',200L)
>>>>print int(c[1])
OK, that would work, if I would know what field contains an Integer or
not...
Could you help to determine weather a value is an Integer or not so I
can to the needed INSERT INTO syntax?
Ansgar
More information about the Python-list
mailing list