magento mysql update table set 更新字段的值

mysql 更改某个字段的值使用 update

UPDATE sales_flat_creditmemo SET new_order_id= 11 WHERE  entity_id = 1

要更改某个或者多个字段的值为空，可以使用下面的命令

UPDATE sales_flat_creditmemo SET `new_order_id`= NULL,`store_credit_used`= NULL  WHERE entity_id = 8844;

UPDATE sales_flat_creditmemo SET `new_order_id`= NULL,`store_credit_used`= NULL  WHERE transaction_id  is NOT NULL;