mysql - 错误 1064 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax?

Question

我想制作一个表格，但出现了这个错误。我需要解决什么问题？

mysql> create database mytest;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| mytest             |
| performance_schema |
| phpmyadmin         |
+--------------------+

5 rows in set (0.00 sec)
mysql> use mytest;
Database changed
mysql> create table price(NAME varchar2(60), PRICE number(10));
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 'varchar2(60), PRICE number(10))' at line 1

Answer 1

您的陈述中还有更多错误:

1) 如果您使用关键字作为字段名称(例如 name

)，则必须使用反引号

2) 没有数据类型 VARCHAR2 使用 VARCHAR 代替

3) 没有数据类型 NUMBER，请使用 INT 代替:

CREATE TABLE price (
    `NAME` VARCHAR(60),
    `PRICE` INT(10)
);

示例

mysql> CREATE TABLE price (
    ->     `NAME` VARCHAR(60),
    ->     `PRICE` INT(10)
    -> );
Query OK, 0 rows affected (0,03 sec)

mysql>