/* Navicat MySQL Data Transfer Source Server : local Source Server Version : 50622 Source Host : localhost:3306 Source Database : test Target Server Type : MYSQL Target Server Version : 50622 File Encoding : 65001 Date: 2017-04-26 11:38:32 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for demo -- ---------------------------- DROP TABLE IF EXISTS `demo`; CREATE TABLE `demo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of demo -- ---------------------------- INSERT INTO `demo` VALUES ('1', 'hong'); INSERT INTO `demo` VALUES ('2', '张三'); INSERT INTO `demo` VALUES ('3', '李四'); INSERT INTO `demo` VALUES ('4', '王五'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `age` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('1', '张三丰', '88');