INSERT INTO customers(cust_id,state,post_code) VALUE(''''Ariel'''',NULL,''''94501''''); 或
INSERT INTO customers(cust_id,state,post_code) VALUE(''''Ariel'''',,''''94501''''); 更新数据
UPDATE命令用于修改表中的数据。
UPDATE order_rollup SET(qty,price)=(SELECT SUM(qty),SUM(price) FROM order_lines WHERE customer_id=''''KOHL'''' WHERE cust_id=''''KOHL'''' AND order_period=TO_DATE(''''01-Oct-2000'''') 删除数据
DELETE语句用来从表中删除一行或多行数据,该命令包含两个语句:
1、关键字DELETE FROM后跟准备从中删除数据的表名。
2、WHERE后跟删除条件
DELETE FROM po_lines WHERE ship_to_state IN (''''TX'''',''''NY'''',''''IL'''') AND order_date 清空表