/*
Navicat MySQL Data Transfer
Source Server : 隔壁老黄
Source Server Version : 50550
Source Host : localhost:3306
Source Database : mydb2
Target Server Type : MYSQL
Target Server Version : 50550
File Encoding : 65001
Date: 2020-08-02 14:55:48
*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for emp-- ----------------------------DROPTABLEIFEXISTS`emp`;CREATETABLE`emp`(`eno`int(11)NOTNULLAUTO_INCREMENTCOMMENT'员工工号',`ename`varchar(255)DEFAULTNULLCOMMENT'姓名',`job`varchar(255)DEFAULTNULLCOMMENT'职位',`hiredate`datetimeDEFAULTNULLCOMMENT'入职时间',`age`int(11)DEFAULTNULLCOMMENT'年龄',`sex`varchar(255)DEFAULTNULLCOMMENT'性别',`sal`varchar(255)DEFAULTNULLCOMMENT'月薪',`dno`int(11)DEFAULTNULLCOMMENT'部门号',PRIMARYKEY(`eno`)USINGBTREE,UNIQUEKEY`INDEX_eno`(`eno`),KEY`fg_dno`(`dno`),CONSTRAINT`fg_dno`FOREIGNKEY(`dno`)REFERENCES`dept`(`dno`))ENGINE=InnoDBAUTO_INCREMENT=124DEFAULTCHARSET=utf8 ROW_FORMAT=COMPACT;-- ------------------------------ Records of emp-- ----------------------------INSERTINTO`emp`VALUES('2','阿卡丽','经理','2017-04-01 00:00:00','31','女','9800',null);INSERTINTO`emp`VALUES('3','露露','普通员工','2020-03-22 00:00:00','22','女','2200','40');INSERTINTO`emp`VALUES('5','阿木木'