|List:||General Discussion||« Previous MessageNext Message »|
|From:||hsv||Date:||June 17 2013 12:44pm|
|Subject:||Re: Update just some of the fields|
|View as plain text|
>>>> 2013/06/17 11:38 +0430, Sayyed Mohammad Emami Razavi >>>> update test set desc='test10' where id=1; <<<<<<<< _That_ is UPDATE! It is the only means of changing, but neither inserting nor deleting, a record. The other fields are left the same. MySQL also tracks whether it is an actual change; this is reflected in the client message Rows matched: ? Changed: ? Warnings: ? . The number after "Changed:" is the number of records where the new value really differs from the old.
|• Update just some of the fields||Sayyed Mohammad Emami Razavi||17 Jun|
|• Re: Update just some of the fields||hsv||17 Jun|