为什么我抄书上的还是报错，哪位帅哥美女能帮我看看的

Question

CREATE TABLE 's' (
'sno'CHAR(10) NOT NULL COMMENT'学号',
'sn'VARCHAR(45) NOT NULL COMMENT'姓名',
'sex'ENUM('男','女') NOT NULL DEFAULT '男' COMMENT'性别',
'age' INT NOT NULL COMMENT'年龄',
'maj' VARCHAR(45) NOT NULL COMMENT'专业’，
‘dep' VARCHAR(45) NOT NULL COMMENT'院系’，
PRIMARY KEY ('sno')
) ENGINE=Inn0DB DEFAULT CHARSET=utf8mb4 C0LLATE=utf8mb4_0900_ai_ci;
s是报错的,'s' is not valid at this position，expecting an identifier

Answer 1

CREATE TABLE s (
sno CHAR(10) NOT NULL COMMENT'学号',
sn VARCHAR(45) NOT NULL COMMENT'姓名',
sex ENUM('男','女') NOT NULL DEFAULT '男' COMMENT'性别',
age INT NOT NULL COMMENT'年龄',
maj VARCHAR(45) NOT NULL COMMENT'专业',
dep VARCHAR(45) NOT NULL COMMENT'院系',
PRIMARY KEY (sno)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 CoLLATE=utf8mb4_0900_ai_ci;