56,687
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE `yuyuelist`
( `ID` INT(10) NULL AUTO_INCREMENT ,
`InDate` DATETIME(20) NULL ,
`InsuranceCompany` VARCHAR(50) NULL ,
`ToDate` DATE NULL ,
`ToTime` VARCHAR(20) NULL ,
`Name` VARCHAR(100) NULL ,
`Tel` VARCHAR(13) NULL ,
`CarBrand` VARCHAR(50) NULL ,
`Model` VARCHAR(100) NULL ,
`CarCode` VARCHAR(50) NULL ,
`Project` VARCHAR(20) NULL ,
`QTY` TINYINT(10) NULL ,
`Colour` VARCHAR(20) NULL ,
`Source` VARCHAR(20) NULL ,
`Store` VARCHAR(20) NULL ,
`Remarks` VARCHAR(200) NULL ,
PRIMARY KEY (`ID`))
ENGINE = InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
#1064 - 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 '(20) NULL ,
`InsuranceCompany` VARCHAR(50) NULL , `ToDate` DATE NULL , `ToTime` ' at line 1
CREATE TABLE `yuyuelist`
( `ID` INT(10) NULL AUTO_INCREMENT ,
`InDate` DATETIME(6) NULL ,
`InsuranceCompany` VARCHAR(50) NULL ,
`ToDate` DATE NULL ,
`ToTime` VARCHAR(20) NULL ,
`Name` VARCHAR(100) NULL ,
`Tel` VARCHAR(13) NULL ,
`CarBrand` VARCHAR(50) NULL ,
`Model` VARCHAR(100) NULL ,
`CarCode` VARCHAR(50) NULL ,
`Project` VARCHAR(20) NULL ,
`QTY` TINYINT(10) NULL ,
`Colour` VARCHAR(20) NULL ,
`Source` VARCHAR(20) NULL ,
`Store` VARCHAR(20) NULL ,
`Remarks` VARCHAR(200) NULL ,
PRIMARY KEY (`ID`))
ENGINE = InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
`InDate` DATETIME(6) NULL ,