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")

Chris Angelico rosuav at
Tue Dec 10 17:28:22 CET 2013

On Wed, Dec 11, 2013 at 3:23 AM, Dan Stromberg <drsalists at> wrote:
> On Mon, Dec 9, 2013 at 12:41 AM, Jai <jaiprakashsingh213 at> 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.

SQL's case insensitive. But I did have to check carefully to see that
that really was correct.


More information about the Python-list mailing list