mysql建表不能用status吗_mysql建表的问题

createtableaccount(idnumber(9)constraintaccount_id_pkprimarykey,recommender_idnumber(9)constraintaccount_recommender_id_fkreferencesaccount(id),login_namevarchar2(30)notn...

create table account

(

idnumber(9) constraint account_id_pk primary key,

recommender_id number(9) constraint account_recommender_id_fk

references account(id),

login_namevarchar2(30) not null constraint account_login_name_uk unique,

login_passwdvarchar2(30) not null,

statuschar(1) constraint account_status_ck check (status in (0,1,2)),

create_datedate default sysdate,

pause_datedate,

close_date date,

real_name varchar2(20)not null,

idcard_nochar(18)not null constraint account_incard_no unique,

birthdatedate,

genderchar(1) constraint account_gender_ck check (gender in (0,1)),

occupationvarchar2(50),

telephonevarchar2(15) not null,

emailvarchar2(50),

mailaddressvarchar2(50),

zipcodechar(6),

qqvarchar2(15),

last_login_time date,

last_login_ipvarchar2(15)

);

报错：

ERROR 1064 (42000): 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 'numbe

r(9) constraint account_id_pk primary key,

recommender_id number(9) ' at line 4

还有，有什么方便一点的ORACLE的模拟软件，在win7下可以运行的

展开