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