每当我尝试创建表并在Python中运行代码
时import MySQLdb
db = MySQLdb.connect("localhost","ayman","1234","Students")
cursor = db.cursor()
query = """CREATE TABLE STUDENT_DETAILS (
ID INT.
NAME CHAR(50),
EMAIL CHAR(10) )"""
cursor.execute(query)
db.close()
我得到了这个结果:
_mysql.connection.query(self, query)
_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 '.ntttNAME CHAR(50), ntttEMAIL CHAR(10) )' at line 2")
可能有什么问题?
问题是查询:
query = """CREATE TABLE STUDENT_DETAILS ( ID INT. NAME CHAR(50), EMAIL CHAR(10) )"""
这可能有效:
query = """CREATE TABLE student_details(id INT, name CHAR(50), email CHAR(10));"""