文件名称：数据修改-数据库培训
文件大小：2.01MB
文件格式：PPT
更新时间：2024-05-15 13:24:23
数据库
数据修改 INSERT INTO Table1(col_name1,col_name2,……) VALUES(value1,value2,……) UPDATE table_name SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... [WHERE where_condition] DELETE FROM table_name [WHERE where_condition] EXAMPLE INSERT INTO employees (employee_id, last_name, email, hire_date, job_id, salary) VALUES (207, 'Gregory', 'pgregory@example.com', sysdate, 'PU_CLERK', 1200); UPDATE employees SET job_id = 'SA_MAN', salary = salary + 1000, department_id = 120 WHERE first_name||' '||last_name = 'Douglas Grant'; DELETE FROM product_descriptions WHERE language_id = 'AR';