[TOC]

建库

create database example default character set utf8 collate utf8_general_ci;

管理员表

建表

create table admin( id int primary key auto_increment, username varchar(30) not null unique, password varchar(30) not null);

插入测试数据

insert into admin(username, password) values(‘admin‘, ‘admin‘);insert into admin(username, password) values(‘cat‘, ‘cat‘);