MYSQL8.0 创建新表

最新推荐文章于 2024-10-07 14:15:35 发布

霸天震月

最新推荐文章于 2024-10-07 14:15:35 发布

阅读量3.8k

点赞数

本文链接：https://blog.csdn.net/newllh/article/details/102971183

版权

CREATE TABLE `kckjmes`.`addb` (
`ID` INT NOT NULL,
`DATETIME` DATETIME NULL,
`JB120` INT NULL,
`JB123A` INT NULL,
`JB123B` INT NULL,
`JB124A` INT NULL,
`JB124B` INT NULL,
`FS408A` INT NULL,
`FS408B` INT NULL,
`JB414A` INT NULL,
`JB414B` INT NULL,
`JB414C` INT NULL,
`JB415A` INT NULL,
`JB415B` INT NULL,
`CJ603A` INT NULL,
`CJ603B` INT NULL,
`CD405A` INT NULL,
`CD405B` INT NULL,
`Demo` VARCHAR(45) NULL,
PRIMARY KEY(`ID`)
);

CREATE TABLE `kckjmes`.`addb` (
`ID` INT NOT NULL,
`DATETIME` DATETIME NULL,
`JB120` DOUBLE NULL,
`JB123A` DOUBLE NULL,
`JB123B` DOUBLE NULL,
`JB124A` DOUBLE NULL,
`JB124B` DOUBLE NULL,
`FS408A` DOUBLE NULL,
`FS408B` DOUBLE NULL,
`JB414A` DOUBLE NULL,
`JB414B` DOUBLE NULL,
`JB414C` DOUBLE NULL,
`JB415A` DOUBLE NULL,
`JB415B` DOUBLE NULL,
`CJ603A` DOUBLE NULL,
`CJ603B` DOUBLE NULL,
`CD405A` DOUBLE NULL,
`CD405B` DOUBLE NULL,
`Demo` VARCHAR(45) NULL,
PRIMARY KEY(`ID`)
);