Can't seem to insert rows into a MySQL table
Marc 'BlackJack' Rintsch
bj_666 at gmx.net
Mon Mar 14 17:55:22 EST 2005
In <mailman.410.1110836641.1799.python-list at python.org>, Anthra Norell
wrote:
> Try to use % instead of a comma (a Python quirk) and quotes around your
> strings (a MySQL quirk):
>
> cursor.execute("INSERT INTO edict (kanji, kana, meaning) VALUES ('%s',
> '%s', '%s')" % ("a", "b", "c") )
AFAIK grumfish made the Right Thing™. If you use '%', some interesting
things can happen, e.g. if your values contain "'" characters. The "%s"s
without quotes and the comma let the DB module format and *escape* the
inserted values for you in a safe way.
Ciao,
Marc 'BlackJack' Rintsch
More information about the Python-list
mailing list