mysql onesql,one.sql · 杨寒冬/8_27mysql - Gitee.com

/*

Navicat MySQL Data Transfer

Source Server : handong

Source Server Type : MySQL

Source Server Version : 50640

Source Host : localhost:3306

Source Schema : one

Target Server Type : MySQL

Target Server Version : 50640

File Encoding : 65001

Date: 28/08/2018 19:23:40

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for users

-- ----------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`age` int(11) NULL DEFAULT NULL,

`sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`phone` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`dest` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,

`money` float(12, 3) NULL DEFAULT NULL,

`birth` timestamp(0) NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------

-- Records of users

-- ----------------------------

INSERT INTO `users` VALUES (5, '郭襄', 18, 'b', '469942@qq.com', '10086', '鲁', 535.673, '2018-04-23 19:20:23');

INSERT INTO `users` VALUES (6, '段誉', 19, 'g', '56884@qq.com', '119', '胡', 45.567, '2017-07-17 17:17:17');

INSERT INTO `users` VALUES (7, '虚竹', 26, 'g', '7899335@zhou.com', '110', '周', 45.567, '2018-06-18 17:09:23');

INSERT INTO `users` VALUES (8, '令狐冲', 23, 'b', '57888@qq.c0m', '16355673421', '谢', 3546.789, NULL);

INSERT INTO `users` VALUES (15, '杨过', 22, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `users` VALUES (16, '张无忌', 25, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `users` VALUES (17, '逍遥子', 58, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `users` VALUES (18, '周伯通', 45, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `users` VALUES (19, '黄药师', 58, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `users` VALUES (20, '王重阳', 56, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `users` VALUES (21, '小可爱', 16, NULL, NULL, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;

一键复制

编辑

Web IDE

原始数据

按行查看

历史