sulin

摘要： 1.update语句 update table set [column,column......] where column ='' 示例： update customers set cust_credit_limit = 20000 where cust_id = 2789;2.delete 语句 delete from table where 条件 示例; delete from customers where cust_state_province = 'QT';备注；truncate customers 也可以删除该表的所有记录，但是它在出错不允许回滚的 阅读全文