45 lines
1.6 KiB
SQL
45 lines
1.6 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localhost
|
|
Source Server Type : MySQL
|
|
Source Server Version : 50557
|
|
Source Host : localhost:3306
|
|
Source Schema : exam-0729
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 50557
|
|
File Encoding : 65001
|
|
|
|
Date: 29/07/2024 09:08:07
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `t_user`;
|
|
CREATE TABLE `t_user` (
|
|
`uid` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
|
|
`userName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
|
|
`pwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
|
|
`sex` int(11) NULL DEFAULT NULL COMMENT '用户年龄',
|
|
`brithday` date NULL DEFAULT NULL COMMENT '用户生日',
|
|
PRIMARY KEY (`uid`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user
|
|
-- ----------------------------
|
|
INSERT INTO `t_user` VALUES (1, '张三', '123', 15, '2024-07-29');
|
|
INSERT INTO `t_user` VALUES (2, '李四', '123', 17, '2024-07-29');
|
|
INSERT INTO `t_user` VALUES (3, '王五', '123', 17, '2024-07-29');
|
|
INSERT INTO `t_user` VALUES (4, '赵六', '123', 26, '2024-07-29');
|
|
INSERT INTO `t_user` VALUES (5, '田七', '123', 22, '2024-07-29');
|
|
INSERT INTO `t_user` VALUES (6, '周八', '132', 21, '2024-07-29');
|
|
INSERT INTO `t_user` VALUES (8, '阿斯顿', '123', 24, '2024-07-29');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|