文章分类 -  数据库 / PostgreSQL

摘要：CREATE INDEX emp_department_ix ON employees (department_id); CREATE INDEX emp_job_ix ON employees (job_id); CREATE INDEX emp_manager_ix ON employees ( 阅读全文

摘要：插入数据 ALTER TABLE departments ALTER CONSTRAINT dept_mgr_fk DEFERRABLE INITIALLY DEFERRED; BEGIN; INSERT INTO departments VALUES ( 10 , 'Administration' 阅读全文

摘要：创建数据表语句 -- 部门信息表 CREATE TABLE departments ( department_id INTEGER NOT NULL -- 部门编号，主键 , department_name CHARACTER VARYING(30) NOT NULL -- 部门名称 , manag 阅读全文