How to create MySQL database in Python?

Question

I run the following Python script and receive the following error message:

mysql_exceptions.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 'check' at line 1")

When I changed the database from check to check1 it the script works and also I didn't have earlier defined "check" database.

import MySQLdb as db
db1 = db.connect(host="localhost",user="root",passwd="vision@123")
cursor = db1.cursor()
sql = "CREATE DATABASE check;"
cursor.execute(sql)
db1.close()

Drew · Accepted Answer · 2015-07-13 00:35:07Z

1

check is a reserved word.

https://dev.mysql.com/doc/refman/5.5/en/keywords.html

The also will fail:

Create database select;

answered Jul 13, 2015 at 0:35

Drew

25k10 gold badges47 silver badges81 bronze badges

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

Comments

Joseph Idziorek · Accepted Answer · 2015-07-13 00:35:32Z

1

Check is a reserved word in MySQL: http://dev.mysql.com/doc/refman/5.7/en/keywords.html and hence the error with "check" and not "check1".

answered Jul 13, 2015 at 0:35

Joseph Idziorek

5,0997 gold badges26 silver badges38 bronze badges

Collectives™ on Stack Overflow

How to create MySQL database in Python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related