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 gmail.com
Tue Dec 10 17:28:22 CET 2013


On Wed, Dec 11, 2013 at 3:23 AM, Dan Stromberg <drsalists at gmail.com> wrote:
>
> 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.

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

ChrisA



More information about the Python-list mailing list