1 CREATE DATABASE books;#创建数据库
2
3 USE books;#使用数据库
4
5 DROP TABLE IF EXISTS `admin`;#删除存在的admin表
6
7 #创建admin表
8 CREATE TABLE `admin` (
9 `aid` int(11) NOT NULL AUTO_INCREMENT,
10 `username` varchar(20) CHARACTER SET gbk COLLATE gbk_bin NOT NULL,
11 `name` varchar(20) DEFAULT NULL,
12 `password` varchar(64) DEFAULT NULL,
13 `email` varchar(255) DEFAULT NULL,
14 `phone` varchar(20) DEFAULT NULL,
15 `status` int(2) DEFAULT '1',
16 `lend_num` int(11) DEFAULT NULL,
17 `max_num` int(11) DEFAULT NULL,
18 PRIMARY KEY (`aid`)
19 ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=gbk;
20
21 #添加数据
22 insert into admin('aid','username','name','password','email','phone','status','lend_num','max_num') values (5,'116','王五','123456','19218495922@qq.com','15825895889',2,0,0);
