<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div class="" style=""><span class="" style="">Hi,</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; background-color: transparent;" class=""><span style="font-family: arial, helvetica, sans-serif;" class="">I was working on </span><font class="" style=""><a href="https://sourceforge.net/p/phpmyadmin/feature-requests/861/" class="" style="">RFE #861</a> (Simulate UPDATE query).</font></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; background-color: transparent;" class=""><font class="" style="">Lets say I have two tables:</font></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; font-family: arial, helvetica, sans-serif; background-color: transparent;" class=""><font class="" style=""><br class="" style=""></font></div><div style="color: rgb(0, 0, 0);
font-size: 13px; font-style: normal; background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">`table_1`</span></div><div style="background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">+----+----------+</span></div><div style="background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">| id | value |</span></div><div style="background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">+----+----------+</span></div><div style="background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">| 10 | value_10 |</span></div><div style="background-color: transparent;" class=""><span
style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">| 20 | value_20 |</span></div><div style="background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class=""><font class="" style=""></font></span></div><div style="background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">+----+----------+</span></div><div style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color: transparent;" class=""><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class=""><br class="" style=""></span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">`table_2`</span></div><div class=""
style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">+----+----------+</span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">| id | value |</span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">+----+----------+</span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">| 10 | value_10 |</span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">| 20 | value_20 |</span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New',
courier, monaco, monospace, sans-serif;" class=""><font class="" style=""></font></span></div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; background-color: transparent;" class=""><span class="" style=""></span></div><div class="" style="background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">+----+----------+</span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class=""><br class="" style=""></span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; background-color: transparent;"><span class="" style="">UPDATE Query</span><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;"
class="">: UPDATE table_1, table_2 SET table_1.value = 'NEW_VALUE', table_2.value='NEW_VALUE' WHERE table_1.id > 10 AND table_2.id > 10;</span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; background-color: transparent;"><span class=""><br></span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; font-family: arial, helvetica, sans-serif; background-color: transparent;"><span class="">This will affect 2 rows.</span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color: transparent;"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class=""><br></span></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color:
transparent;">How to simulate this query using SELECT statement?</div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color: transparent;"><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color: transparent;">I was trying:</div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-style: normal; background-color: transparent;"><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; background-color: transparent;"><span style="color: rgb(34, 34, 34); font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class="">SELECT DISTINCT table_1.value, table_2.value FROM table_1, table_2 WHERE table_1.value <>
'NEW_VALUE' AND table_2.value <> 'NEW_VAUE' AND table_1.id > 10 AND table_2.id > 10;</span><br class="" style=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13px; font-style: normal; font-family: arial, helvetica, sans-serif; background-color: transparent;"><span style="color: rgb(34, 34, 34); font-family: 'Courier New', courier, monaco, monospace, sans-serif;" class=""><br></span></div><div class="" style="color: rgb(34, 34, 34); font-size: 13px; font-style: normal; background-color: transparent;"><span style="color: rgb(34, 34, 34);" class="">but this only returns 1 row.</span></div><div class="" style="color: rgb(34, 34, 34); font-size: 13px; font-style: normal; font-family: arial, helvetica, sans-serif; background-color: transparent;"><span style="color: rgb(34, 34, 34);" class="">Can this be done in a single query only?</span></div><div class="" style=""></div><div class="" style=""> </div><div class=""
style="">Regards,
<br class="" style="">Ashutosh Dhundhara</div></div></body></html>