weixin_45958862的博客

表结构 SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; – Table structure for class DROP TABLE IF EXISTS class; CREATE TABLE class ( cid INT(11) NOT NULL AUTO_INCREMENT, caption VARCHAR(32) NOT NULL, PRIMARY KEY (cid) ) ENGINE=INNODB AUTO_INCREMENT=5 DEFAULT CH

表结构 CREATE DATABASE emp_sys CHARSET=utf8; USE emp_sys; CREATE TABLE dept ( deptno INT PRIMARY KEY, dname VARCHAR(14), loc VARCHAR(23) ); CREATE TABLE emp ( empno INT PRIMARY KEY, ename VARCHAR(20), job VARCHAR(20), mgr INT, hiredate DATE, sal NUMERIC(7,2),

表结构 – 部门表 CREATE TABLE dept ( id INT PRIMARY KEY PRIMARY KEY, – 部门id dname VARCHAR(50), – 部门名称 loc VARCHAR(50) – 部门位置 ); – 添加4个部门 INSERT INTO dept(id,dname,loc) VALUES (10,‘教研部’,‘北京’), (20,‘学工部’,‘上海’), (30,‘销售部’,‘广州’), (40,‘财务部’,‘深圳’); – 职务表，职务名称，职务描述 CREA