Inserting into a database

aditya shukla adityashukla1983 at gmail.com
Mon Oct 12 01:46:17 CEST 2009


Hello Guy's

I am using python 2.6 on windows 7 and MySQLdb to make connections to the
database.The issue here is that I  am not able to insert from the python
script to the database.When I run the same query in mysql query brower then
the insert statement works .I am able to select from the database  using the
python script.The connection is fine.I am using Aptana to write the python
script.

I thought this could be a problem of the collation or character set problem
the default character set  of the system is cp1252 which corrosponds to
latin_1 on mysql , I have chosen that and still no help. Any help is
appreciated.


Thanks

Aditya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20091011/2f611d86/attachment.html>


More information about the Python-list mailing list