crebas.sql

来自「一个用户管理系统的例子,作的很好,有前端,有后台,增加,删除,修改,查找都可以实」· 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)    
)