Skip to content

sql

create table:

CREATE TABLE table_name (
    id          bigint not null primary key,
    value       varchar(255) not null,
);

create table if not exists:

CREATE TABLE IF NOT EXISTS table_name (
    id          bigint not null primary key,
    value       varchar(255) not null,
);

insert:

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); 

update:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

change database name:

ALTER TABLE table_name
RENAME TO new_table_name;

drop table: DROP TABLE table_name;

delete: DELETE from table_name where <conditions>