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求大侠帮忙看看,哪里出错了?
pid INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
name VARCHAR(50) NOT NULL,
age INT NOT NULL,
score FLOAT ,
salary FLOAT ,
type INT
);