MySQL-错误 1064 (42000)
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/17158420/
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 17:57:28 来源:igfitidea点击:
MySQL- error 1064 (42000)
提问by u2464168
mysql> use j****
Database changed
mysql> show tables;
Database setup was all right
+---------------------+
| Tables_in_j******** |
+---------------------+
| fos_user |
| goal |
| goal_type |
| industry |
| interval |
| target |
| user |
+---------------------+
7 rows in set (0.11 sec)
mysql> explain interval;
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 to use near 'inter
val' at line 1
mysql>
I can explain all other tables, except this one.And how can i write the insert command sentence. Thanks
我可以解释所有其他表，除了这个表。我该如何编写插入命令语句。谢谢
回答by u2464168
Interval is a special name for MySQL. We can't create it with normal creating sentence.
间隔是 MySQL 的一个特殊名称。我们不能用普通的造句造句。
explain `interval`;
It should like this. Thank to @ypercube
它应该是这样的。感谢@ypercube
