blocks|key|1081192|text|这是一个明显的错误：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1081193|PlayerID,+INT+NOT+NULL+AUTO_INCREMENT|code-block|syntax|javascript|1081194|你有一个多余的逗号。它应该是：|1081195|PlayerID+INT+NOT+NULL+AUTO_INCREMENT|1081196|也不要在SQL语句的下一行中加上逗号！|1081197|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

This is an obvious error:

<pre><code>PlayerID, INT NOT NULL AUTO_INCREMENT
</code></pre>

You have an extraneous comma. It should be:

<pre><code>PlayerID INT NOT NULL AUTO_INCREMENT
</code></pre>

Stop putting commas on the next line of your SQL statements as well!

blocks|key|294759|text|这里有一个关于语法错误消息的提示:该消息告诉您错误在哪里。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|294760|检查与您的MySQL服务器版本相对应的手册，以获得正确的语法，以便使用近‘INT，而不是空的AUTO_INCREMENT|blockquote|294761|这告诉你，MySQL之所以感到困惑，是因为它没有预料到会看到这段文字。这通常意味着你在这一点上犯了一个错误，或者就在它之前。|294762|这可以帮助您将SQL语句中的搜索范围缩小到出错的程度。|294763|错误信息还告诉您应该做什么：检查手册。您应该通过阅读文档和示例来帮助自己更好地使用SQL。|offset|length|style|BOLD|294764|我已经使用MySQL将近20年了，但我仍然每天都引用参考文档。事实上，因为我对MySQL有经验，所以我知道这是正确的做法。|294765|在手册中，所有SQL语句都有一个参考页。下面是创建表的页面：https://dev.mysql.com/doc/refman/5.7/en/create-table.html|294766|MySQL手册很大，所以很容易认为“我不知道正确的页面在哪里”。渐渐地，你可以了解手册是如何组织的。注意左边列中链接的层次结构。当有疑问时，只需使用Google的短语，如"mysql创建表语法“。|294767|您应该能够自己回答简单的语法错误，而不是投递到堆栈溢出。你会很快得到答案的！|294768|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/create-table.html^0|0|0|0|0|E|5|0|0|U|1L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|16|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|17|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|18|8|@$K|19|L|1A|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1C|8|@]|9|@$K|1D|L|1E|1|1F]]|A|$]]|$1|S|3|T|5|6|7|1G|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

Here's a tip about syntax error messages: the message tells you where the error is.

<blockquote>
 check the manual that corresponds to your MySQL server version for the right syntax to use near ' INT NOT NULL AUTO_INCREMENT
</blockquote>

This is telling you that MySQL became confused because it wasn't expecting to see that text. This usually means you made a mistake at that point, or immediately before it.

This can help you narrow down your search in the SQL statement to the point where it went wrong.

The error message also tells you what to do: check the manual. You should help yourself become better at SQL by reading documentation and examples. 

I've been using MySQL for nearly 20 years, but I still refer to the reference docs every day. In fact, it's because I am experienced with MySQL that I know this is the right thing to do.

All SQL statements have a reference page in the manual. Here's the page for CREATE TABLE: <a href="https://dev.mysql.com/doc/refman/5.7/en/create-table.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/create-table.html</a>

The MySQL manual is large, so it's easy to think "I don't know where the right page is." Gradually you can learn how the manual is organized. Pay attention to the hierarchy of links on the left column. When in doubt, just use Google for phrases like "mysql create table syntax".

You should be able to answer simple syntax errors for yourself instead of posting to Stack Overflow. You'll get your answer more quickly!

blocks|key|294773|text|这应该能行。你在PlayerID后面有一个逗号|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|294774|CREATE+TABLE+bowling_scores+(
++++PlayerID+INT+NOT+NULL+AUTO_INCREMENT,
++++LName+VARCHAR(100)+NOT+NULL,
++++FName+VARCHAR(100)+NOT+NULL,
++++Game1+INT+NULL,
++++Game2+INT+NULL,
++++Game3+INT+NULL,
++++Game4+INT+NULL,
PRIMARY+KEY+(PlayerID)
);|code-block|syntax|javascript|294775|entityMap^0|8|8|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

This should work. You had a comma after <code>PlayerID</code>

<pre><code>CREATE TABLE bowling_scores (
 PlayerID INT NOT NULL AUTO_INCREMENT,
 LName VARCHAR(100) NOT NULL,
 FName VARCHAR(100) NOT NULL,
 Game1 INT NULL,
 Game2 INT NULL,
 Game3 INT NULL,
 Game4 INT NULL,
PRIMARY KEY (PlayerID)
);
</code></pre>

blocks|key|1081266|text|你应该写这样的东西：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1081267|creat+table+Bowling_score(Playerid+int,+Firstname+varchar(100),+Lastname+varchar(100),+Game1+int,+Game2+int,+Game3+int);|code-block|syntax|javascript|1081268|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You should be writing something like:

<pre><code>creat table Bowling_score(Playerid int, Firstname varchar(100), Lastname varchar(100), Game1 int, Game2 int, Game3 int);
</code></pre>

I am trying to create a table, but it gives me this error:

<blockquote>
 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax touse near ' INT NOT NULL AUTO_INCREMENT
</blockquote>

Here is my code:

<pre><code> CREATE TABLE bowling_scores (
 PlayerID, INT NOT NULL AUTO_INCREMENT
 , LName VARCHAR(100) NOT NULL
 , FName VARCHAR(100) NOT NULL
 , Game1 INT NULL
 , Game2 INT NULL
 , Game3 INT NULL
 , Game4 INT NULL
 , PRIMARY KEY (PlayerID)
 );
</code></pre>

ERROR 1064 (42000), when creating a mysql table

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我正在尝试创建一个表，但是它给了我一个错误：错误1064 (42000)：您的SQL语法出现了错误；请检查与MySQL服务器版本对应的手册，以获得“INT NULL AUTO_INCREMENT”附近的正确语法这是我的代码：    CREATE TABLE bowling_scores (    PlayerID, I...

问创建mysql表时出错1064 (42000)
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问创建mysql表时出错1064 (42000)EN