mysql> CREATE TABLE person(
-> pid INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
-> name VARCHAR(50) NOT NULL,
-> age INT NOT NULL,
-> score FLOAT ,
-> salary FLOAT ,
-> type INT
-> );
ERROR 1064 (42000): 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 'TABLE
person(
pid INT AUTO_INCREMENT PRIMARY KEY NOT NULL' at line 1求大侠帮忙看看,哪里出错了?
解决方案 »
- 数据库启动报错
- SELECT id FROM reviews WHERE MATCH (data) AGAINST ('single') 没有结果返回
- MYSQL 从longtext中像百度那样获取部分字符串的。。。。。
- 如何从mysql结果集中得到每条记录的blob长度?
- cent0s 5.3该下载哪个版本的 mysql安装文件比较合适
- 没分了,不过求好心人帮忙
- PreparedStatement和Statement有什么区别啊?
- 数据库繁体问题,救命!
- 安装时出以下提示,怎么办,装不上.
- Lost Connections to MYSQL server during query
- Mysql 索引
- delphi+MySQL问题
pid INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
name VARCHAR(50) NOT NULL,
age INT NOT NULL,
score FLOAT ,
salary FLOAT ,
type INT
);