建表删表SQL语句

创建

用use xxxx来制定schema

CREATE TABLE rlb_record (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘自增ID’,
sid varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘业务ID’,
gid varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘游戏ID’,
aid varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘活动ID’,
tkey varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘类型’,
pid varchar(50) NOT NULL DEFAULT ‘0’ COMMENT ‘主体ID’,
cid varchar(20) NOT NULL DEFAULT ‘0’ COMMENT ‘附属ID’,
val bigint(11) NOT NULL DEFAULT ‘0’ COMMENT ‘数值’,
skey varchar(20) NOT NULL DEFAULT ‘0’ COMMENT ‘使用标准’,
operation tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘动作类型，加:1,减:2’,
ip varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘用户IP’,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘创建时间’,
PRIMARY KEY (id),
KEY idx_sid_gid_pid (sid,gid,aid,tkey,pid) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘排行榜-记录表’

删除

drop 删除表结构与数据
truncate 清空数据
delete 清空特定行数据