Skip to content

SQL

CREATE TABLE new_table AS
TABLE existing_table;
SELECT *, id as "new_name"
FROM
    existing_table
WHERE
    condition;
DELETE FROM table_name
WHERE condition;
UPDATE table_name
SET column1 = value1,
    column2 = value2,
    ...
WHERE condition;

Last update: 2022-11-04