crebas.sql

来自「jsp页面的一些关键技术,里面有我上课时的很多例子,大家不妨看看.」· SQL 代码 · 共 30 行

create table admin
(
    id int auto_increment,
    uname varchar(15) not null,
    pwd varchar(15) not null,
    primary key(id)    
)

insert into admin(uname, pwd) 
   values('admin', '123');
insert into admin(uname, pwd) 
   values('root', '456');
create table sysuser
(
    id int auto_increment,
    uname varchar(15) not null,
    pwd varchar(15) not null,
    rname varchar(20),
    gender varchar(2),
    birthday date,
    email varchar(40) not null,
    phone varchar(15),
    college varchar(30),
    degree varchar(2),
    province varchar(6),
    city varchar(6),
    hobbies varchar(20),
    introduction varchar(512),
    primary key(id)    
)