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;