请教下面的SQL语句有什么错误
下面是段java关于数据库的操作 所用数据库是mysql请高手帮忙看哈有什么错误的?
stmt.executeUpdate("create table bookinfo(id INT not null primary
key,title VARCHAR(50) not null,author VARCHAR(50) not null,bookconcern VARCHAR(100) not
null,publish_date DATE not null,price FLOAT(4,2) not null,amout SMALLINT,remark
VARCHAR(200))ENGINE = InnoDB");
下面是编译的错误
CreateDBServlet.java:39: 未结束的字符串字面值
stmt.executeUpdate("create table bookinfo(id INT not nul
l primary
^
CreateDBServlet.java:40: 不是语句
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 不是语句
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 不是语句
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 不是语句
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:40: 需要 ';'
key,title VARCHAR(50) not null,author VARCHAR(50) not nu
ll,bookconcern VARCHAR(100) not
^
CreateDBServlet.java:41: 需要 ';'
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:41: 不是语句
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:41: 需要 ';'
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:41: 需要 ';'
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:41: 不是语句
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:41: 需要 ';'
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:41: 需要 ';'
null,publish_date DATE not null,price FLOAT(4,2) not nul
l,amout SMALLINT,remark
^
CreateDBServlet.java:42: 需要 ';'
VARCHAR(200))ENGINE = InnoDB");
^
CreateDBServlet.java:42: 未结束的字符串字面值
VARCHAR(200))ENGINE = InnoDB");
^
21 错误