闄堟旦澶?/p>
MySQL5.5
鏁版嵁搴撴暀绋?/p>
V1.2
鏃堕棿锛?/p>
2012
骞?/p>
11
鏈?/p>
鎺堣锛氶檲娴╁
鐗堟潈鎵�鏈夛細闄堟旦澶?/p>
SQL
绠�鍗曟煡璇㈢粌涔犻
涓�銆?/p>
琛ㄧ粨鏋勮鏄?/p>
1.
闆囧憳琛?/p>
(emp)
闆囧憳琛細
emp
瀛楁
涓枃鍚?/p>
绫诲瀷
闀垮害
鍙栧�艰鏄?/p>
empno
闆囧憳缂栧彿
INT
涓诲仴
ename
鍛樺伐濮撳悕
VARCHAR
20
NOT NULL
job
宸ヤ綔鑱屼綅
VARCHAR
50
mgr
闆囧憳鐨勯瀵硷紙缁忕悊锛夌紪鍙?/p>
INT
hiredate
鍏ヨ亴鏃ユ湡
DATE
sal
鏈堣柂
/
宸ヨ祫
INT
comm
濂栭噾
INT
deptno
闆囧憳鎵�灞為儴闂ㄧ殑缂栧彿
INT
2.
閮ㄩ棬琛?/p>
(dept)
閮ㄩ棬琛細
dept
瀛楁
涓枃鍚?/p>
绫诲瀷
闀垮害
鍙栧�艰鏄?/p>
deptno
閮ㄩ棬缂栧彿锛堝敮涓�锛?/p>
INT
涓诲仴
dname
閮ㄩ棬鍚嶇О
VARCHAR
20
NOT NULL
loc
鍦板潃
VARCHAR
50
3.
宸ヨ祫绛夌骇琛?/p>
(salgrade)
宸ヨ祫鐧昏琛細
salgrade
瀛楁
涓枃鍚?/p>
绫诲瀷
闀垮害
鍙栧�艰鏄?/p>
grade
绛夌骇鍚嶇О
INT
losal
姝ょ瓑绾х殑鏈�浣庡伐璧?/p>
INT
hisal
姝ょ瓑绾х殑鏈�楂樺伐璧?/p>
INT