mysql命令总结

最新推荐文章于 2020-08-21 10:48:32 发布

weixin_34357267

最新推荐文章于 2020-08-21 10:48:32 发布

阅读量181

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/3639899/blog/1829566

版权

2019独角兽企业重金招聘Python工程师标准>>>

1、新增字段

alter table oc_customer add email_status tinyint(1) NOT NULL DEFAULT 0;
alter table oc_customer add phone_status tinyint(1) NOT NULL DEFAULT 0;
alter table oc_customer add token_exptime int(11) NOT NULL DEFAULT 0;
alter table oc_customer add token_email varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

2、创建数据表

DROP TABLE IF EXISTS `oc_customer_active_email`;
CREATE TABLE `oc_customer_active_email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NULL DEFAULT NULL,
`token_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`token_exptime` int(11) NULL DEFAULT NULL,
`email_status` int(1) NULL DEFAULT NULL,
`addtime` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;

转载于:https://my.oschina.net/u/3639899/blog/1829566