数据操作

1.INSERT

INSERT INTO<表名>（列名1，列名2，……，列名n）

VALUES（列值表达式1，列值表达式2，……，列值表达式n）;

INSERT INTO employee (last_name, first_name, hire_date, bitrhdate, salary_amount, employee_number)

VALUES(……)

2.INSERT-SELECT

INSERT INTO emp_copy

SELECT * FROM emp;

【创建一张雇员生日表】

CREATE TABLE birthdays

(empno INTEGER NOT NULL

,lname CHAR(20) NOT NULL

,fname VARCHAR(30)

,birth DATE)

UNIQUE PRIMARY INDEX(empno);

【从雇员表中提取生日信息添加到生日表中】

INSERT INTO birthdays

  SELECT employee_number, last_name, first_name, birthdate

  FROM employee;

3.UPDATE

UPDATE<表名>

   SET<列名1> = <z列值表达式1>

           ,<列名2> = <列值表达式2>

            ,...

     WHERE <条件子句>;

UPDATE employee

SET department_number = 403

,job_code = 432101

,manager_employee_number = 1005

WHERE employee_number = 1010;