[Phpmyadmin-devel] Simulate UPDATE query

Ashutosh Dhundhara ashutoshdhundhara at yahoo.com
Fri Jun 13 19:00:36 CEST 2014


Hi,
I was working on RFE #861 (Simulate UPDATE query).
Lets say I have two tables:

`table_1`
+----+----------+
| id | value    |
+----+----------+
| 10 | value_10 |
| 20 | value_20 |
+----+----------+

`table_2`
+----+----------+
| id | value    |
+----+----------+
| 10 | value_10 |
| 20 | value_20 |
+----+----------+

UPDATE Query: 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;

This will affect 2 rows.

How to simulate this query using SELECT statement?

I was trying:

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;


but this only returns 1 row.
Can this be done in a single query only?
 
Regards, 
Ashutosh Dhundhara
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140613/4271d342/attachment.html>


More information about the Developers mailing list