MySQL数据库语法-多表查询练习一

             1
            /*
             2
            @author :yinzhengjie

             3
            Blog:http://www.cnblogs.com/yinzhengjie/tag/%E6%95%B0%E6%8D%AE%E5%BA%93%E4%BB%8E%E5%85%A5%E9%97%A8%E5%88%B0%E7%B2%BE%E9%80%9A/

             4
            EMAIL:y1053419035@qq.com

             5
            */
             6
             7
            create
            table
             dept(

             8     did intprimarykey auto_increment,
 9     dname varchar(10)
10);
1112createtable emp(
13     eid intprimarykey auto_increment,
14     name varchar(10),
15     salary int,
16     dno int,
17foreignkey emp(dno)  references dept(did)
18);
1920insertinto dept values(null,‘市场部‘);
21insertinto dept values(null,‘研发部‘);
22insertinto dept values(null,‘财务部‘);
23insertinto dept values(null,‘后勤部‘);
24insertinto emp values(null,‘邓西‘,15000,1);
25insertinto emp values(null,‘李贤敬‘,8000,2);
26insertinto emp values(null,‘杨明明‘,7000,2);
27insertinto emp values(null,‘尹正杰‘,100000000,3);
28insertinto emp values(null,‘陶涛‘,10000,1);
29insertinto emp values(null,‘方合意‘,9800,1);
30insertinto emp values (null,‘邓聪聪‘,13000,null);
31insertinto emp values (null,‘李亚超‘,15000,null);