搜索结果
查询Tags标签： emp01，共有 4条记录-
数据库——连接查询
创建副表CREATE TABLE emp01( eid INT PRIMARY KEY AUTO_INCREMENT, ename VARCHAR(10), esex CHAR(5), did INT, CONSTRAINT fk_emp01_dept01 FOREIGN KEY(did) REFERENCES dept01(did) -- 外键约束)新增数据INSERT INTO dept01(dname,mgr) VALUES(开发部,tom);INSERT IN…
2021/9/26 19:11:25 人评论 次浏览 -
数据库——连接查询
创建副表CREATE TABLE emp01( eid INT PRIMARY KEY AUTO_INCREMENT, ename VARCHAR(10), esex CHAR(5), did INT, CONSTRAINT fk_emp01_dept01 FOREIGN KEY(did) REFERENCES dept01(did) -- 外键约束)新增数据INSERT INTO dept01(dname,mgr) VALUES(开发部,tom);INSERT IN…
2021/9/26 19:11:25 人评论 次浏览 -
9.22mysql学习
-- 默认值约束CREATE TABLE teacher( tid INT, tname VARCHAR(10), addr VARCHAR(30) DEFAULT 山东淄博)SELECT * FROM teacherINSERT INTO teacher VALUES(1,李老师,山东济南)INSERT INTO teacher(tid,tname) VALUES(2,张老师)INSERT INTO teacher VALUES(3,徐老师,NULL)…
2021/9/22 19:10:09 人评论 次浏览 -
9.22mysql学习
-- 默认值约束CREATE TABLE teacher( tid INT, tname VARCHAR(10), addr VARCHAR(30) DEFAULT 山东淄博)SELECT * FROM teacherINSERT INTO teacher VALUES(1,李老师,山东济南)INSERT INTO teacher(tid,tname) VALUES(2,张老师)INSERT INTO teacher VALUES(3,徐老师,NULL)…
2021/9/22 19:10:09 人评论 次浏览
