建表 语法

1、创建一个用户表：
CREATE TABLE qp_member (
id int(11) NOT NULL AUTO_INCREMENT,
customer_id int(11) NOT NULL COMMENT ‘所属客户id’,
parent_id int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘上级id’,
member_name varchar(30) NOT NULL DEFAULT ‘’ COMMENT ‘用户账号’,
real_name varchar(60) NOT NULL DEFAULT ‘’ COMMENT ‘用户姓名’,
password varchar(60) NOT NULL DEFAULT ‘’ COMMENT ‘密码’,
token varchar(64) NOT NULL DEFAULT ‘’ COMMENT ‘token’,
safe_password varchar(60) NOT NULL DEFAULT ‘’ COMMENT ‘保险箱密码’,
phone char(11) NOT NULL DEFAULT ‘’ COMMENT ‘手机号码’,
email varchar(125) NOT NULL DEFAULT ‘’ COMMENT ‘邮箱’,
wechat varchar(60) NOT NULL DEFAULT ‘’ COMMENT ‘微信’,
level varchar(15) NOT NULL DEFAULT ‘’ COMMENT ‘等级’,
agency_level varchar(15) NOT NULL DEFAULT ‘’ COMMENT ‘代理等级’,
agency_amount decimal(10,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘代理总额’,
team_num int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘成员数’,
qq varchar(15) NOT NULL DEFAULT ‘’ COMMENT ‘qq号码’,
balance decimal(10,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘余额’,
is_frozen tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否冻结余额0否1是’,
binding_bank tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘是否绑定银行卡’,
bank_info varchar(255) NOT NULL DEFAULT ‘’ COMMENT ‘银行卡信息’,
safe_balance decimal(10,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘保险箱余额’,
commission decimal(10,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘可领取佣金’,
commission_total decimal(10,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘累计获得佣金’,
deposit_num int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘存款次数’,
deposit_amount decimal(12,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘存款总额’,
withdrawal_num int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘取款次数’,
withdrawal_amount decimal(12,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘取款总额’,
order_num int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘注单量’,
bet_amount decimal(12,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘投注金额’,
effi_bet_amount decimal(10,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘有效投注金额’,
invitation_code varchar(10) NOT NULL DEFAULT ‘’ COMMENT ‘邀请码’,
last_login_time datetime DEFAULT NULL COMMENT ‘最后一次登录时间’,
last_login_ip varchar(15) NOT NULL DEFAULT ‘’ COMMENT ‘最后一次登录ip’,
sex tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘性别0保密1男2女’,
birthday varchar(15) NOT NULL DEFAULT ‘’ COMMENT ‘生日’,
province_id int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘省份id’,
city_id int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘城市id’,
area varchar(125) NOT NULL DEFAULT ‘’ COMMENT ‘城市/地区’,
status tinyint(1) unsigned NOT NULL DEFAULT ‘1’ COMMENT ‘账号启用状态0停用1启用’,
register_time datetime DEFAULT NULL COMMENT ‘添加时间’,
PRIMARY KEY (id) USING BTREE,
KEY cus_inx (customer_id),
KEY mem_name (member_name)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT=‘会员表’;

2、根据已有的表创建新表：

create table tab_new like tab_old (使用旧表创建新表)

example ：
create table qp_member_bet like qp_member; 数据库会有两张表表中内容一至 稍加修改即可

3、删表：drop + table+要删除的表名

drop table tabname
example ：
drop table qp_member_bet;