Aura Dev
A
Aura Dev

SQL Cheatsheet

Essential SQL commands and queries.

Data Manipulation (DML)

SELECT

SELECT col1, col2 FROM table_name;

INSERT

INSERT INTO table_name (col1, col2) VALUES (val1, val2);

UPDATE

UPDATE table_name SET col1 = val1 WHERE condition;

DELETE

DELETE FROM table_name WHERE condition;

Data Definition (DDL)

CREATE TABLE

CREATE TABLE table_name (
  id INT PRIMARY KEY,
  name VARCHAR(50) NOT NULL
);

ALTER TABLE

ALTER TABLE table_name ADD column_name datatype;

DROP TABLE

DROP TABLE table_name;

Joins

INNER JOIN

SELECT * FROM A
INNER JOIN B ON A.id = B.id;

LEFT JOIN

SELECT * FROM A
LEFT JOIN B ON A.id = B.id;

Filtering & Grouping

WHERE & LIKE

SELECT * FROM table WHERE name LIKE '%John%';

GROUP BY & HAVING

SELECT col, COUNT(*) FROM table
GROUP BY col
HAVING COUNT(*) > 1;

What is SQL?

SQL (Structured Query Language) is the standard language for managing and manipulating relational databases.

This cheatsheet provides a quick reference for common SQL operations, including SELECT queries, JOINs, aggregations, and table modifications.

Sponsored LinkAdvertisement Space (728x90)