mysql数据库内容导出,MySql数据库导出

mysql数据库内容导出,MySql数据库导出

/*

Navicat Premium Data Transfer

Source Server : 刘文鹏

Source Server Type : MySQL

Source Server Version : 50540

Source Host : 127.0.0.1:3306

Source Schema : danielcar

Target Server Type : MySQL

Target Server Version : 50540

File Encoding : 65001

Date: 18/09/2019 23:13:14

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

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

-- Table structure for admin

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

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`adminname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,

`password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

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

-- Records of admin

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

INSERT INTO `admin` VALUES (1, '张美群', '111');

INSERT INTO `admin` VALUES (2, '程锦', '222');

INSERT INTO `admin` VALUES (3, '大哥', '333');

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

-- Table structure