Code Snippets
SQL Snippets
Creation
Create Table
CREATE TABLE users (
id INT PRIMARY KEY,
name VARCHAR(100)
);
Create Index
CREATE INDEX idx_name ON users(name);
Create Database
CREATE DATABASE mydb;
Create View
CREATE VIEW active_users AS
SELECT * FROM users WHERE active = 1;
Management
Insert Data
INSERT INTO users (id, name) VALUES (1, 'John');
Update Data
UPDATE users SET name = 'Jane' WHERE id = 1;
Delete Data
DELETE FROM users WHERE id = 1;
Alter Table
ALTER TABLE users ADD email VARCHAR(255);
Selection
Select All
SELECT * FROM users;
Select Columns
SELECT id, name FROM users;
Select Distinct
SELECT DISTINCT name FROM users;
Select with Order
SELECT * FROM users ORDER BY name ASC;
Filtering
Where Clause
SELECT * FROM users WHERE id = 1;
Where with AND
SELECT * FROM users WHERE id > 0 AND active = 1;
Where with LIKE
SELECT * FROM users WHERE name LIKE 'J%';
Where with IN
SELECT * FROM users WHERE id IN (1, 2, 3);
Back to categories