mysql练习:员工部门表(含答案)
建表和添加数据创建部门表CREATE TABLE dept(deptno INT,dname varchar(14),loc varchar(13));添加部门数据INSERT INTO dept values(10, ‘ACCOUNTING’, ‘NEW YORK’);INSERT INTO dept values(20, ‘RESEARCH’, ‘DALLAS’);INSERT INTO dept values(30, ‘SALES’, ‘CHICAGO’);INSERT I
原创
2020-07-25 15:10:53 ·
14108 阅读 ·
4 评论