derby sql错误 错误 42X01：语法错误：Encountered "(" at line

Question

创建表的时候总是报这个错误：错误 42X01：语法错误：Encountered "(" at line 2, column 28。
这是具体的信息：
[code="java"]ij> create table student
(id int(2) generated by default as identity,
name varchar(12) not null,
totalScore int(3) not null,
chinese int(2) not null,
maths int(2) not null,
english int(2) not null);
错误 42X01：语法错误：Encountered "(" at line 2, column 28。
ij>[/code]为什么呢

Answer 1

在命令行中不要换行