Sql syntax check the manual

SQL Error 1064, SQLState 42000 You have an error in your.

_pppn=r1&_dcat=93427&LH_Item Condition=1000|1500" link1 =db.escape_string(link) page = urllib2.urlopen(link) soup = Beautiful Soup(page) Contents = All(itemprop = "name") lst_content = [] for x in Contents: x = x.string lst_content.append(x) Price = All(itemprop = "price") lst_price =[] for y in Price: y = y.string lst_price.append(y) for x , y in zip(lst_content, lst_price): sql = """insert into `category` (url, catagory,price) VAl UES ('%s', '%s', '%s')"""%(link1,x,y) #print sql sql = unicodedata.normalize('NFKD', sql).encode('ascii','nore') #sys.exit(0) cursor.execute(sql) db.commit() db.close() error occur Programming Error: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your My SQL server version for the rht syntax to use near 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Re: Programming Error: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your My SQL server version for the rht syntax to use near 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") [ In reply to ] Programming Error: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your My SQL server version for the rht syntax to use near 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Though you haven't given the full traceback, I suspect that the lines above are what is causing your problem.

Php - You have an error in your SQL syntax; check the

Delegating Constructor Accessor Instance(Unknown Source) at reflect.

MySQL 5.6 Reference <i>Manual</i>

PHP, Apache, MySQL, Windows WampServer

Programming Error: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your My SQL server version for the rht syntax to use near 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") from Beautiful Soup import Beautiful Soup import re, urllib2, My SQLdb #My SQLdb.escape_string(" ") import sys import unicodedata if __name__=="__main__": #link = raw_input("Enter the url link: ") db = My SQLdb.connect("localhost","root","", "ebay") cursor=db.cursor() link = "

MySQL 5.6 Reference Manual

SQLState Converter.convert(SQLState Converter.java: at sun.reflect. Native Constructor Accessor Instance0(Native Method) at sun.reflect.


Sql syntax check the manual:

Rating: 87 / 100

Overall: 100 Rates

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *