46 lines
1.7 KiB
SQL
46 lines
1.7 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : 106.54.199.209
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80400
|
||
Source Host : 106.54.199.209:3306
|
||
Source Schema : test_7.29
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80400
|
||
File Encoding : 65001
|
||
|
||
Date: 29/07/2024 09:16:12
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `user`;
|
||
CREATE TABLE `user` (
|
||
`uid` int NOT NULL AUTO_INCREMENT COMMENT '用户id，主键，自增',
|
||
`userName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户姓名',
|
||
`pwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
|
||
`sex` int NULL DEFAULT NULL COMMENT '用户年龄',
|
||
`brithday` date NULL DEFAULT NULL COMMENT '用户生日',
|
||
PRIMARY KEY (`uid`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of user
|
||
-- ----------------------------
|
||
INSERT INTO `user` VALUES (1, '张三', '123', 15, '2024-07-17');
|
||
INSERT INTO `user` VALUES (2, '李四', '123', 21, '2024-07-30');
|
||
INSERT INTO `user` VALUES (3, '王五', '123', 20, '2024-06-19');
|
||
INSERT INTO `user` VALUES (4, '赵柳', '123', 18, '2024-03-21');
|
||
INSERT INTO `user` VALUES (5, '陈七', '123', 19, '2024-02-14');
|
||
INSERT INTO `user` VALUES (6, '六九', '123', 17, '2023-09-21');
|
||
INSERT INTO `user` VALUES (8, '呃呃', '123', 20, '2024-06-12');
|
||
INSERT INTO `user` VALUES (9, '方法', '123', 25, '2021-12-09');
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|