Re: 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]

On Wed, Dec 11, 2013 at 3:23 AM, Dan Stromberg <drsali...@gmail.com> wrote:
>
> On Mon, Dec 9, 2013 at 12:41 AM, Jai <jaiprakashsingh...@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.
SQL's case insensitive. But I did have to check carefully to see that
that really was correct.

ChrisA
-- 
https://mail.python.org/mailman/listinfo/python-list