1? 新增? ?INSERT

INSERT INTO 表名（列1，列2，列3...）VALUES（值1，值2，值3...）

INSERT INTO t_jobs(job_id,job_title,MIN_SALARY,MAX_SALARY)

VALUES('Java Le','Java Lecturer',2500,9000);

2? 修改 UPDATE

UPDATE 表名 SET 列1=新值1，?列2=新值2，...WHERE 條件；

UPDATE? t_employees? SET salary =25000? WHERE EMPLOYEE_ID='100';? ? ? ? （單值）

UPDATE t_employees SET JOB_ID='ST MAN',salary=3500 WHERE EMPLOYEE_ID='135';???（多值）

3? 刪除? DELETE

DELETE??FROM? 表名? WHERE? 條件；? ? #? 對(duì)數(shù)據(jù)做操作

DELETE FROM t_employees WHERE EMPLOYEE_ID='135';? ?# 刪除135號(hào)員工

DELETE FROM t_employees?WHERE FIRST_NAME='Peter' AND? LAST_NAME='Hal1';

4? 清空整表數(shù)據(jù)? TRUNCATE

TRUNCATE TABLE 表名? ? ? ? ? ? ? ? ? ? # 對(duì)表做操作

TRUNCATE? TABLE??t1;