user.sql

来自「与大家分享」· SQL 代码 · 共 19 行

drop table user_o;

create table  user_o
(  
   name       varchar,
   password   varchar,
   sex        varchar,
   age        int,
   email      varchar,
   state      varchar,
   callnumber int,
   head       varchar,
     
   PRIMARY KEY(name)
   
);

insert into user_o values('zhanghaibo' , '123456','male',18,'[e-mail]','',1,'');
insert into user_o values('zhangli' , '654321','female',18,'[e-mail]','',2,'');