数据[4]数据处理DataStoreMysql

MySQL常见命令

　创建唯一索引

CREATE UNIQUE INDEX uk_content_type ON corpus(content,type_id);

修改字段类型

ALTER TABLE roster ADD COLUMN del_flag int(1) DEFAULT 0 NOT NULL COMMENT ‘删除标识’;

ALTER TABLE corpus add unique index uk_content(user_account_id,game_id,daily_date);

ALTER TABLE roster MODIFY COLUMN del_flag COMMENT ‘0:没有删除,1:已删除’;

ALTER TABLE freeze_white_list ADD column com_id bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘公司Id’;

权限配置

1
2
3
4
grant all privileges on *.* to nova identified by 'quantumcs';
flush privileges;
// 本地用户访问权限
grant all privileges on *.* to nova@'127.0.0.1' identified by 'quantumcs';

mysql表占用空间