MySQL SQL 语句中的语法错误（如果不存在则创建表）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22544136/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-31 20:16:36 来源:igfitidea点击:
syntax error in SQL statement (create table if not exists)
提问by Elembur
CREATE TABLE IF NOT EXISTS ax_storage
(PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID),
Playername VARCHAR(32),
Time INT(10), Type INT(6),
World VARCHAR(32);
What is wrong with this SQL statement?
这个 SQL 语句有什么问题？
回答by Fabio
You are missing to close a paranthesis at the end of the query
您缺少在查询结束时关闭括号
CREATE TABLE IF NOT EXISTS ax_storage
(
PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID), Playername VARCHAR(32),
Time INT(10),
Type INT(6),
World VARCHAR(32)
); -- <- you were missing this one
回答by echo_Me
you forgot )in the end of query
你)在查询的最后忘记了
CREATE TABLE IF NOT EXISTS ax_storage (PID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(PID), Playername VARCHAR(32), Time INT(10), Type INT(6), World VARCHAR(32));
