Python3 issue with SQL insert

Question

I am running intoan issue with the below. It says

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 'INSERT\xc2\xa0INTO\xc2\xa0no.top_new VALUES\xc2\xa0(title,\xc2\xa0link,\xc2\xa0description)' at line 1")

I am not sure what is wrong with the query?

 import feedparser, MySQLdb
    db = MySQLdb.connect(host='localhost',user='root',passwd='sdsdf', db='no')
    mycursor = db.cursor()
    d = feedparser.parse('https://news.yahoo.com/rss/entertainment')

    for post in d.entries:
        title = post.title
        link = post.link
        description = post.description
        sql = '''INSERT INTO no.top_new VALUES (title, link, description)'''
        mycursor.execute(sql)

seems that the problem is related to nbsp; characaters instead of spaces — Flash Thunder
– Flash Thunder, Commented Sep 11, 2019 at 9:14

matwr · Accepted Answer · 2019-09-11 09:09:02Z

1

You are not specifying the columns in your INSERT query. This is fine. However, you must ensure that your table has precisely the same number of columns as the inserted values (in your case three) and that the columns in the table structure are in the same order as your INSERT values. Hence, I suspect that your table either has additional columns or is not structured in the order of your given values: tite|link|description.

EDIT

If the structure is correct. Then the issue is likely to be related to the data being inserted, which likely contains invalid characters.

Solution : Rewrite your INSERT query as follows:

sql = "INSERT INTO no.top_new VALUES (%s, %s, %s)"
mycursor .execute(sql, (title, link,description))

This way the string to be inserted will be escaped for you.

edited Sep 11, 2019 at 9:09

answered Sep 11, 2019 at 8:11

matwr

1,5811 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

kikee1222 Over a year ago

hi there - the table has the same structure exactly. I did also try to specify input columns, but it had the same error

matwr Over a year ago

In that case, I suspect there is an issue with escaping the data being inserted. Try the following format: sql = "INSERT INTO no.top_new VALUES (%s, %s, %s)" mycursor .execute(sql, (title, link,description))

Collectives™ on Stack Overflow

Python3 issue with SQL insert

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related