>>>> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
