新建表:
DROP TABLE IF EXISTS `t_skin`;
CREATE TABLE `t_skin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
`skin_key` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '皮肤类型str',
`skin_name` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '皮肤类型描述',
`n_delete` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '记录状态,预留字段;1表示正常;',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
insert into `t_skin`(`id`,`skin_key`,`skin_name`,`n_delete`) values (1,'hard','硬笔皮肤',1),(2,'soft','软笔皮肤',1),(3,'xileng','西冷皮肤',1);
mysql 修改表字段:加到csdn
ALTER TABLE t_test MODIFY COLUMN n_type TINYINT UNSIGNED COMMENT '1.xxxx;2.xxx ';
ALTER TABLE t_users CHANGE reg_mode user_from TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '1表示自己注册,2表示由运营平台手动创建' ;
修改表字段的默认值:
ALTER TABLE t_feedback_message MODIFY create_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE t_users ALTER COLUMN device_num_limit SET DEFAULT 5;
删除表字段:
alter table t_user_to_course drop column lastly_cancel_time;
新增表字段:
ALTER TABLE t_course ADD skin VARCHAR(15) NOT NULL DEFAULT '' COMMENT 'xxx' AFTER pack_url ;
创建唯一(unique)索引:
ALTER TABLE t_users ADD UNIQUE unique_account_phone(`account`,`phone`);