我们可以写注释来创建一个表:
create database `mytest`;
use `mytest`;
create table `mytest` (
/* mytest mytest */
`code` varchar(15) NOT NULL,
`type` varchar(20) NOT NULL
);
如何/* mytest mytest */
在创建表命令中显示注释?
show create table mytest;
+--------+------------------------------------+
| Table | Create Table |
+--------+------------------------------------+
| mytest | CREATE TABLE `mytest` (
`code` varchar(15) NOT NULL,
`type` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4