ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1")

Dan Stromberg drsalists at gmail.com
Tue Dec 10 11:23:27 EST 2013


On Mon, Dec 9, 2013 at 12:41 AM, Jai <jaiprakashsingh213 at gmail.com> wrote:

>
>         sql = """insert into `category` (url, catagory,price) VAlUES
> ('%s', '%s', '%s')"""%(link1,x,y)
>

Is that VALUES or VAlUES or VAIUES?   It probably should be VALUES.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20131210/54d76d0a/attachment.html>


More information about the Python-list mailing list