CREATE TABLE member(
memberid varchar(10) NOT NULL,
membercard varchar (20) NOT NULL,
totalcost float NOT NULL,
regdate datetime NOT NULL
);
使用的中文括号么?按照下边这个试试看
CREATE TABLE member(
memberid varchar(10) NOT NULL,
membercard varchar (20) NOT NULL,
totalcost float NOT NULL,
regdate datetime NOT NULL);