On Mon, Jun 16, 2014 at 9:15 PM, Hugues Peccatte <hugues.peccatte@gmail.com> wrote:

2014-06-13 19:00 GMT+02:00 Ashutosh Dhundhara <ashutoshdhundhara@yahoo.com>:

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

Hi,

Isn't it possible to run the query with 

set AUTOCOMMIT=0;

and a rollback at the end?

Hugues.