-- MySQL dump 10.13 Distrib 5.7.43, for Linux (x86_64)
--
-- Host: localhost Database: work
-- ------------------------------------------------------
-- Server version 5.7.43
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Current Database: `work`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `work` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `work`;
--
-- Table structure for table `dept`
--
DROP TABLE IF EXISTS `dept`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dept` (
`deptno` int(11) NOT NULL AUTO_INCREMENT,
`dname` varchar(20) DEFAULT NULL,
`LOCAL` varchar(20) DEFAULT NULL,
PRIMARY KEY (`deptno`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dept`
--
LOCK TABLES `dept` WRITE;
/*!40000 ALTER TABLE `dept` DISABLE KEYS */;
INSERT INTO `dept` VALUES (10,'会计','纽约'),(20,'研发','北京'),(30,'销售','上海'),(40,'实施','深圳');
/*!40000 ALTER TABLE `dept` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `emp`
--
DROP TABLE IF EXISTS `emp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `emp` (
`EMPNO` int(11) NOT NULL AUTO_INCREMENT,
`ENAME` varchar(20) DEFAULT NULL,
`Job` varchar(20) DEFAULT NULL,
`Mgr` int(11) DEFAULT NULL,
`Hiredate` int(11) DEFAULT NULL,
`Sal` decimal(7,2) DEFAULT NULL,
`Comm` decimal(7,2) DEFAULT NULL,
`deptno` int(11) DEFAULT NULL,
PRIMARY KEY (`EMPNO`),
KEY `fk_deptno` (`deptno`),
CONSTRAINT `fk_deptno` FOREIGN KEY (`deptno`) REFERENCES `dept` (`deptno`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `emp`
--
LOCK TABLES `emp` WRITE;
/*!40000 ALTER TABLE `emp` DISABLE KEYS */;
INSERT INTO `emp` VALUES (7369,'SMITH','职员',7902,19801217,800.00,NULL,20),(7499,'ALLEN','销售',7698,19820220,1600.00,300.00,30),(7521,'WARD','销售',7698,19810222,1250.00,500.00,30),(7566,'JONES','经理',7839,19810402,2975.00,NULL,20),(7654,'MARTIN','销售',7698,19810928,1250.00,1400.00,30),(7698,'BLANK','经理',7839,19810501,2850.00,NULL,30),(7782,'CLARK','经理',7839,19810609,2450.00,NULL,10),(7788,'SCOTT','分析师',7566,19870419,3000.00,NULL,20),(7839,'KING','总裁',NULL,19811117,5000.00,NULL,10),(7844,'TURNER','销售',7698,19810908,1500.00,0.00,30),(7876,'ADAMS','职员',7788,19870523,1100.00,NULL,20),(7900,'JAMES','职员',7698,19811203,950.00,NULL,30),(7902,'FORD','分析师',7566,19811203,3000.00,NULL,20),(7934,'MILLER','职员',7782,19820123,1200.00,NULL,10);
/*!40000 ALTER TABLE `emp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `salgrade`
--
DROP TABLE IF EXISTS `salgrade`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `salgrade` (
`grade` int(11) DEFAULT NULL,
`Losal` int(11) DEFAULT NULL,
`Hisal` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `salgrade`
--
LOCK TABLES `salgrade` WRITE;
/*!40000 ALTER TABLE `salgrade` DISABLE KEYS */;
INSERT INTO `salgrade` VALUES (1,700,1200),(2,1201,1400),(3,1401,2000),(4,2001,3000),(5,3001,9999);
/*!40000 ALTER TABLE `salgrade` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tbl_account`
--
DROP TABLE IF EXISTS `tbl_account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`money` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tbl_account`
--
LOCK TABLES `tbl_account` WRITE;
/*!40000 ALTER TABLE `tbl_account` DISABLE KEYS */;
INSERT INTO `tbl_account` VALUES (1,'Tom','1000'),(2,'Jerry','500'),(3,'Lisa','2000'),(4,'John','1500');
/*!40000 ALTER TABLE `tbl_account` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-09-09 11:02:25
网站首页 > gitee 正文
- 上一篇: sql练习表
- 下一篇: Merge list with Linq.
猜你喜欢
- 2024-04-13 javaweb学习记录
- 2024-04-13 常用论坛网站
- 2024-04-13 convnet源代码解析(一):基础准备
- 2024-04-13 rpc的学习
- 2024-04-13 Face-landmarks-detection-benchmark 人脸特征定位网站汇总
- 2024-04-13 2011-2-10 学习总结
- 2024-04-13 Chernoff-Hoeffding inequality -- Chernoff bounds, and some applications
- 2024-04-13 用Python演奏音乐
- 2024-04-13 Python网络编程
- 2024-04-13 21个开源项目强烈建议收藏
你 发表评论:
欢迎- 04-25用微服务平台框架,实现高效的流程化办公!
- 04-25国内主流的低代码开发平台 2024最好用的低代码厂商大全
- 04-25出生率持续下降,而低代码,成了!
- 04-25再探前端低代码的“野路子”
- 04-25APaaS 企业级低代码平台 All In One
- 04-25 巨头布局,资本支持,低代码的好时代要来了?
- 04-25开源微服务低代码的几大亮点内容
- 04-25微服务 SaaS 低代码开发平台
- 0℃未命名
- 最近发表
- 标签列表
-
- gitee (437)
- 码云 (330)
- vant (426)
- pig (303)
- bee (372)
- 文件存储系统 (317)
- gitee图片不显示 (348)
- kettleweb (315)
- 百度开源 (335)
- vs助手 (309)
- crypto-js.js (361)
- vue-element-admin (380)
- g6 (352)
- vconsole (370)
- python基础教程 (329)
- roses (325)
- 表单设计器 (317)
- oa办公 (329)
- yii2 (406)
- uni-ui (362)
- psutil (336)
- hikaricp (386)
- 超级转换 (328)
- tigervnc (328)
- cs-notes (299)
本文暂时没有评论,来添加一个吧(●'◡'●)