Python MYSQLDB Insert Syntax Error

Question

I'm trying to insert data into my database and I get a MYSQL syntax error using this code:

import MySQLdb
db=MySQLdb.connect(host="localhost",user="root",passwd="",db="database")
cursor = db.cursor()
sql = "INSERT INTO table1('col1','col2') values ('val1','val2');"
cursor.execute(sql)
db.commit()

What was the syntax error that you got? Edit your question.

John Machin
– John Machin

2012-04-19 22:23:35 +00:00
Commented Apr 19, 2012 at 22:23 — John Machin
– John Machin, Commented Apr 19, 2012 at 22:23

Jeff Allen · Accepted Answer · 2012-04-19 22:19:02Z

2

No quotes around the column names.

INSERT INTO table1(col1, col2) VALUES ('val1', 'val2');

You could use backticks around the column names, but not single quotes.

answered Apr 19, 2012 at 22:19

Jeff Allen

17.6k9 gold badges52 silver badges70 bronze badges

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

2 Comments

Noah R Over a year ago

What do you mean, can you paste the code that you're referring to? I see quotes around them.

John Machin Over a year ago

@NoahR: he means "quotes not allowed around column names"

Collectives™ on Stack Overflow

Python MYSQLDB Insert Syntax Error

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