CREATE TABLE booklist( -> ISBN varchar(100) not null, -> name varchar(100) CHARACTER SET gb2312, -> price float, -> chubanData date, -> PRIMARY KEY(ISBN)
时间: 2023-06-23 08:09:33 浏览: 97
缺少最后一个分号,正确的语法应该是:
CREATE TABLE booklist (
ISBN varchar(100) NOT NULL,
name varchar(100) CHARACTER SET gb2312,
price float,
chubanDate date,
PRIMARY KEY (ISBN)
);
阅读全文