CREATE TABLE `app_user1` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT '' COMMENT '用户昵称',
`email` varchar(50) NOT NULL COMMENT '用户邮箱',
`phone` varchar(20) DEFAULT '' COMMENT '手机号',
`gender` tinyint(100) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
`password` varchar(100) NOT NULL COMMENT '密码',
`age` tinyint(4) DEFAULT '0' COMMENT '年龄',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `id_app_user_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2000001 DEFAULT CHARSET=utf8 COMMENT='app用户表';
DELIMITER //
CREATE PROCEDURE mock_data3()
BEGIN
DECLARE num int DEFAULT 1000000;
DECLARE i int DE
mysql 写入百万条数据,创建时间不一致
最新推荐文章于 2023-02-01 19:28:28 发布