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")
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.
More information about the Python-list