Transform complex UPDATE in SELECT (for testing)
Helping users to quickly understand SQL queries
Brought to you by:
legrand_legrand
UPDATE tab
set col = ( Sub1 )
where
...
and EXISTS ( Sub2)
-->
SELECT
col,
(Sub1)
from tab
where
...
This feature is available from
Query builder > syntax editor and check the diagram layout.
Command editor > select text , right click and format query.
Diff: