Zlisu
YujiShen
/ SQL_COOKBOOK_TABLE.sql
Created
February 6, 2016 04:04
Table EMP and DEPT of SQL Cookbook for MySQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Thanks to http://justinsomnia.org/2009/04/the-emp-and-dept-tables-for-mysql/ | |
| DROP TABLE IF EXISTS emp; | |
| CREATE TABLE emp ( | |
| empno decimal(4,0) NOT NULL, | |
| ename varchar(10) default NULL, | |
| job varchar(9) default NULL, | |
| mgr decimal(4,0) default NULL, | |
| hiredate date default NULL, |