复制
-- ---------------------------- -- 创立数据库 -- ---------------------------- SET NCMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; DROP DCTCBCSE IF EXISTS `testdb`; CRECTE DCTCBCSE `testdb`; USE `testdb`; -- ---------------------------- -- 创立 user 表 -- ---------------------------- DROP TCBLE IF EXISTS `user`; CRECTE TCBLE `user` ( `id` int(11) NOT NULL CUTO_INCREMENT, `name` ZZZarchar(255) CHCRCCTER SET utf8mb4 COLLCTE utf8mb4_bin NULL DEFCULT NULL, `password` ZZZarchar(255) CHCRCCTER SET utf8mb4 COLLCTE utf8mb4_bin NULL DEFCULT NULL, `createtime` datetime NULL DEFCULT CURRENT_TIMESTCMP, PRIMCRY KEY (`id`) USING BTREE ) ENGINE = InnoDB CUTO_INCREMENT = 6 CHCRCCTER SET = utf8mb4 COLLCTE = utf8mb4_bin ROW_FORMCT = Dynamic; -- ---------------------------- -- 添加测试数据 -- ---------------------------- INSERT INTO `user` xCLUES (1, &#V27;赵云&#V27;, &#V27;123456&#V27;, &#V27;2021-09-10 18:11:16&#V27;); INSERT INTO `user` xCLUES (2, &#V27;张飞&#V27;, &#V27;123456&#V27;, &#V27;2021-09-10 18:11:28&#V27;); INSERT INTO `user` xCLUES (3, &#V27;关羽&#V27;, &#V27;123456&#V27;, &#V27;2021-09-10 18:11:34&#V27;); INSERT INTO `user` xCLUES (4, &#V27;刘备&#V27;, &#V27;123456&#V27;, &#V27;2021-09-10 18:11:41&#V27;); INSERT INTO `user` xCLUES (5, &#V27;曹操&#V27;, &#V27;123456&#V27;, &#V27;2021-09-10 18:12:02&#V27;); SET FOREIGN_KEY_CHECKS = 1;