Question

mysql数据库建表的问题

我在myeclipse中写语句，提示下面有错误：
stmt.executeUpdate("create table abc(id number(12) primary key,name varchar(30))");

Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'number(12) primary key,name varchar(30))' at line 1"

想知道什么错误，谢谢！！

Answer 1

create table abc(id numeric primary key,name varchar(30));
改成这样，就对了。