Hello.
Is it time to unify command syntax?
Classic insert as update
INSERT table_name
SET column1 = value1, column2 = value2, ...
Insert as update from select
INSERT table_name
SET column1 = other_table.colum1, column2 = other_table.colum2, ...
FROM other_table
WHERE condition;
Benefits:
- unified syntax with update command
- clearer parameters
- Convenient search for errors in SQL statements
Have a nice day
Zdenek