您可以使用ENGINE = InnoDB代替TYPE = InnoDB,因为TYPE的用法在MySQL 5.1版中已过时。
我们用于示例的版本是MySQL 8.0.12。让我们检查MySQL版本。查询如下-mysql> select version();
以下是输出-+-----------+
| version() |
+-----------+
| 8.0.12 |
+-----------+
1 row in set (0.00 sec)
这是TYPE = InnoDB的示例。错误在MySQL 8中可见-mysql> create table Product_Information
-> (
-> ProductId int,
-> ProductName varchar(10),
-> ProductDeliveryDate datetime
-> )"TYPE = InnoDB";
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 '"TYPE = InnoDB"' at line 6
现在使用ENGINE代替TYPE。这是引擎的一个例子-mysql> create table Product_Information
-> (
-> ProductId int,
-> ProductName varchar(10),
-> ProductDeliveryDate datetime
-> )ENGINE = InnoDB;