sql 语句
CREATE DATABASE school CHARSET=UTF8;
USE school;
SHOW TABLES;
CREATE TABLE banji(
bjBianHao INT,
bjMingCheng VARCHAR(16),
PRIMARY KEY(bjBianHao)
);
CREATE TABLE student(
stuNo INT AUTO_INCREMENT,
stuName VARCHAR(4),
sex VARCHAR(1),
birthday DATE,
score FLOAT(4,1),
isPartyMember BOOLEAN,
PRIMARY KEY(stuNo)
);
报错信息
如图,提示我在 PRIMARY KEY(banjiBianHao) 附近有错,请问错在何处,望不吝赐教。
bjMingCheng VARCHAR(16),
PRIMARY KEY(bjBianHao) 中间 多了一个逗号