hi i have reserve table with 4 column,one of them id,
i wana update 3 other column,but when one of this query is like before query dont work!!!
may be each of this 3 column have previous value to update this row,see below example:
mytable:column1=id,column2=breakfastid,column3=lunchid,column4=dinnerid,
if one row values is like this:{id=1,breakfastid=3,lunchid=4,dinnerid=1},
this query works:UPDATE reserve SET breakfastid=1,
lunchid=3,
dinnerid=2 WHERE id=1
BUT
this query dont work return empty :UPDATE reserve SET breakfastid=3,
lunchid=3,
dinnerid=2 WHERE id=1
i know its because breakfastid value is like previous value,but i wana other columns (lunchid and dinnerid)update,
how to handle this in situations like this ?