Inserting into a database

[aditya shukla]

On Sun, Oct 11, 2009 at 5:06 PM, aditya shukla
<adityashukla1983 at gmail.com>wrote:

> Hello Stephen,
>





>
> I have put the code and the traceback.Can you please help me now? .I am
> scratching my head :)
>
> 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.
>
> this what the code looks like.
>
>
> db = MySQLdb.connect("localhost","root","juventus12","factoids",charset =
> "utf8", use_unicode = True )
> cursor= db.cursor()   # i added charset = "utf8", use_unicode = True just
> now and changed the character set of mysql still no help.
>
> cursor.execute("""INSERT INTO question_table
> (question_id,source_id,question) VALUES (5,1,"question")""")
>
>
> language, output_encoding = locale.getdefaultlocale()
>
> print output_encoding, language
>
>
> traceback
>
> C:\Python26\lib\site-packages\MySQLdb\__init__.py:34: DeprecationWarning:
> the sets module is deprecated
>   from sets import ImmutableSet
>
> cp1252 en_US
>
> Thanks
>
> Aditya
>
>
>
>
>
>
>
>
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20091011/18d7fa4e/attachment.html>