我正尝试在MySQL工作台中使用python创建表,但每次运行时都会收到一个错误消息:“从MySQL表1064读取数据时出错(42000):您的SQL语法中有一个错误;请查看与您的MySQL服务器版本对应的手册,了解在第1行'‘附近使用的正确语法。”
import mysql.connector
from mysql.connector import Error
try:
connection = mysql.connector.connect(host='localhost',
database='project2',
user='root',
password='123')
sql_select_Query = ("CREATE TABLE customer (custID int,custName VARCHAR(25), zip int, city VARCHAR(25), state VARCHAR(25)")
cursor = connection.cursor()
cursor.execute(sql_select_Query)
print("customer Table is Created in the Database")
except mysql.connector.Error as e:
print("Error reading data from MySQL table", e)
finally:
if connection.is_connected():
connection.close()
cursor.close()
print("MySQL connection is closed")我一直在尝试各种不同的方法来做这件事,但我总是遇到错误
发布于 2021-11-23 04:14:52
你只是在sql中漏掉了一个")“,试试这个:
sql_select_Query = ("CREATE TABLE customer (custID int,custName VARCHAR(25), zip int, city VARCHAR(25), state VARCHAR(25))")请更彻底地阅读您自己的代码。如果你再次发现这个错误,这里有一个简单的技巧:
<代码>G211
发布于 2021-11-23 04:14:02
sql_select_Query = ("CREATE TABLE customer (custID int,custName VARCHAR(25), zip int, city VARCHAR(25), state VARCHAR(25)")查询命令末尾缺少):
sql_select_Query = ("CREATE TABLE customer (custID int,custName VARCHAR(25), zip int, city VARCHAR(25), state VARCHAR(25))")发布于 2021-11-23 04:18:07
结束最后的括号:
CREATE TABLE customer (custID int,custName VARCHAR(25), zip int, city VARCHAR(25), state VARCHAR(25));https://stackoverflow.com/questions/70075269
复制相似问题