CREATE TABLE `user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`phone` varchar(32) DEFAULT NULL,
`pwd` varchar(128) DEFAULT NULL,
`sex` int(2) DEFAULT NULL,
`img` varchar(128) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`role` int(11) DEFAULT NULL COMMENT '1是普通⽤户，2是管理员',
`username` varchar(128) DEFAULT NULL,
`wechat` varchar(128) DEFAULT NULL, PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `user` (`id`, `phone`, `pwd`, `sex`, `img`, `create_time`, `role`,
`username`,`wechat`)
VALUES
(1,'123','666',1,'xdclass.net','2021-09-09
00:00:00',1,'jack','xdclass6'),
(2,'2323432','794666918',1,'wwwww','2020-05-20 04:54:01',1,'
⼩滴Anna姐姐','xdclass-anna'),
(3,'2323432','xdclass-lw',1,'wwwww','2020-05-20 04:54:42',1,'⼆当家⼩D','xdclass1'),
(4,'2323432','3232323',1,'wwwww','2020-05-20 04:55:07',1,'⽼王','xdclass-lw');
https://blog.csdn.net/qq_42914528/article/details/81509853