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.

Thread
Update just some of the fieldsSayyed Mohammad Emami Razavi17 Jun
  • Re: Update just some of the fieldshsv17 Jun