1. 创建管理员信息表(Administrators)
1.1 MySQL语句
use database;
create table administrators
(
id smallint unsigned auto_increment primary key,
adminname varchar(20),
adminpwd varchar(20),
admintype varchar(20)
);
2. 添加表注释
alter table 表名 comment '注释内容'
3. 复制表结构
create table table_new like table_old