6 Star 7 Fork 4

huhuics/mPayTradeCore

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
test.sql 2.61 KB
一键复制 编辑 原始数据 按行查看 历史
huhuics 提交于 2016-06-23 21:31 . 创建mPayTradeCore
/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.5.28 : Database - test
*********************************************************************
*/
/*!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*/`test` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `test`;
/*Table structure for table `department` */
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(32) DEFAULT NULL COMMENT '部门名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Data for the table `department` */
insert into `department`(`id`,`name`) values (1,'Java技术部');
/*Table structure for table `user` */
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(40) NOT NULL COMMENT '姓名',
`password` varchar(255) NOT NULL COMMENT '密码',
`age` int(4) NOT NULL COMMENT '年龄',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
/*Data for the table `user` */
insert into `user`(`id`,`name`,`password`,`age`) values (1,'宋江0','songjiang',39),(2,'宋江1','songjiang',39),(3,'宋江2','songjiang',39),(4,'宋江3','songjiang',39),(6,'宋江4','songjiang',39),(7,'宋江5','songjiang',39),(8,'宋江6','songjiang',39),(9,'宋江7','songjiang',39),(13,'宋江8','songjiang',39),(14,'宋江9','songjiang',39),(15,'宋江10','songjiang',39),(16,'宋江11','songjiang',39),(17,'宋江12','songjiang',39),(18,'宋江13','songjiang',39),(19,'宋江14','songjiang',39),(20,'宋江15','songjiang',39),(28,'宋江16','songjiang',39),(29,'宋江17','songjiang',39),(30,'宋江18','songjiang',39),(31,'宋江19','songjiang',39),(32,'宋江20','songjiang',39),(33,'宋江21','songjiang',39),(34,'宋江22','songjiang',39),(35,'宋江23','songjiang',39),(36,'宋江24','songjiang',39),(37,'宋江25','songjiang',39),(38,'宋江26','songjiang',39),(39,'宋江27','songjiang',39),(40,'宋江28','songjiang',39),(41,'宋江29','songjiang',39),(42,'宋江30','songjiang',39),(43,'宋江31','songjiang',39);
/*!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 */;
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/huhuics/mPayTradeCore.git
git@gitee.com:huhuics/mPayTradeCore.git
huhuics
mPayTradeCore
mPayTradeCore
master

搜索帮助

0d507c66 1850385 C8b1a773 1850385