List:General Discussion« Previous MessageNext Message »
From:Sayyed Mohammad Emami Razavi Date:June 17 2013 7:08am
Subject:Update just some of the fields
View as plain text  
In MySQL when i execute full update query, all fields will be updated or
no? It means, which fields that have not been changed will not be updated?!

e.g.
current values for table named 'test', i want to update just desc:
id, name, desc
1, test1, test2

update test set name='test1', desc='test10' where id=1;

I use one framework that still does not implement update just changed
fields, i know that i can use this:

update test set desc='test10' where id=1;

any ideas?!

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