Question

我试图制作一张叫作 car的薄片。 I m目前通过MAMP(WAMP的Mac版本)使用Sandamyadmin。

在我点击“光子”时,这一错误似乎:

    SQL query:

CREATE TABLE `cardatabase`.`CARTABLE` (
`ID` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`SLOTNUMBER` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`STATUS` ENUM( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`LATITUDE` DECIMAL( 20 ) NOT NULL ,
`LONGITUDE` DECIMAL( 20 ) NOT NULL ,
`LOCATION` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`DEVICEID` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#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  1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `LATITUDE` DECIMAL(20) N  at line 1

这似乎是一个双重数据类型的问题,因为当我改变数据类型,使表格制作起来时。是否有其他办法? 事先感谢任何帮助。

Answer 1

你的问题是:

`STATUS` ENUM( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,

缩略语

rel=“nofollow noreferer”>MySQL doco

“ENUM”是一个直观物体,其价值从表制作时间专栏列出的允许数值清单中选定。

点数价值必须是引出的字面;它可能不是一个表述,哪怕是评价了直观价值。

Answer 2

您在直线上有错误,需要预先确定如下面值:

STATUS ENUM ( ravi , kotwani ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NUL,

全面询问:

CREATE TABLE cardatabase.CARTABLE ( ID VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , SLOTNUMBER VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , STATUS ENUM ( ravi , kotwani ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NUL, LATITUDE DECIMAL( 20 ) NOT NULL , LONGITUDE DECIMAL( 20 ) NOT NULL , LOCATION VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , DEVICEID VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

友情链接