Trouble with Myqsl

[Steve Holden]

"Jon Ribbens" <jon+usenet at unequivocal.co.uk> wrote in message
news:slrnacc59a.tg8.jon+usenet at snowy.squish.net...
> In article <u3ex8.94967$T%5.10614 at atlpnn01.usenetserver.com>, Steve Holden
wrote:
> > This error was caused by Fernando's following a bogus suggestion of
mine.
> > His original SQL syntax was correct
>
> Uh, no it wasn't, he was using '%s' instead of %s. I'm confused now.

<sigh> Sorry, I should have had the courage of my own convictions. When
Fernando told me he was still getting errors on his SQL I assumed that the
MySQLdb module required delimiters around string parameters. You're right,
this doesn't make any sense. You should have been confused. It eventually
transpired that Fernando had an install problem, which a clean reinstall
fixed.

>>> import MySQLdb
>>> c = MySQLdb.connect(db="pwpsite")
>>> cc = c.cursor()
>>> cc.execute("SHOW TABLES")
5L
>>> cc.fetchall()
(('chapter',), ('comment',), ('part',), ('remark',), ('reviews',))
>>> cc.execute("CREATE TABLE tmp (k integer primary key, s char(12))")
0L
>>> cc.execute("INSERT INTO tmp (k, s) VALUES (%s, %s)",
...     [(1, "one"), (2, 'two'), (3, 'three')] )
3L

So, for the record, you should *not* put SQL string quotes around parameter
markers in your parameterized SQL statements.

regards
 Steve
--

home: http://www.holdenweb.com/
Python Web Programming:
http://pydish.holdenweb.com/pwp/