Mysql是5.5.62,phpmyadmin建表,语句如下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 ,
`Res` 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 请问哪里出了问题?
( `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 ,
`Res` 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 请问哪里出了问题?
解决方案 »
- 朋友创业,需要游戏开发高手做数据库开发,请大家指点
- ERROR 1194 (HY000): Table 'links' is marked as crashed and should be repaired
- 急。。跪求指教Navicat for MySQL
- 如何用sql在一个表内完成按字段值重复记录拆分成多个表
- 初接触 mysql 求指引。。。
- 急,菜鸟求解
- 老土问题:mysql jdbc取出来的数据中文显示乱码
- 装mysql服务出现的怪现象,请帮忙看看
- 只能使用root,密码是空的帐户吗?
- 一句sql语句的苦恼!
- 小白问!MySQL创建的新连接里为什么会有旧连接里的数据库?
- mysql 多对一进行数据同步
( `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 ,
`Res` VARCHAR(200) NULL ,
PRIMARY KEY (`ID`))
ENGINE = InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;