💾

SQL Cheatsheet

Data Query Language (DQL)

SELECT
Extracts data from a database
FROM
Specifies which table to select or delete data from
WHERE
Filters a result set to include only records that fulfill a specified condition

Data Manipulation Language (DML)

INSERT INTO
Inserts new data into a database
UPDATE
Updates data in a database
DELETE
Deletes data from a database

Data Definition Language (DDL)

CREATE TABLE
Creates a new table
ALTER TABLE
Modifies a table
DROP TABLE
Deletes a table