none
Unification of syntax for update and insert commands RRS feed

  • Obecná diskuse

  • 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

    středa 4. září 2019 7:25

Všechny reakce