mybatis-3.2.x.jar

/* SQLyog 企业版 - MySQL GUI v8.14 MySQL - 5.5.40 : Database - kdcnews ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`kdcnews` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `kdcnews`; /*Table structure for table `studentss` */ DROP TABLE IF EXISTS `studentss`; CREATE TABLE `studentss` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sName` varchar(255) DEFAULT NULL, `age` int(11) DEFAULT NULL, `addres` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `studentss` */ insert into `studentss`(`id`,`sName`,`age`,`addres`) values (1,'张三',18,'qwe'),(2,'张无忌',19,'光明顶'),(3,'张三丰',100,'武当山'),(4,'郭靖',30,'襄阳'),(5,'杨过',26,'山洞'),(28,'王五',22,'上海'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;