1/71
Looks like no tags are added yet.
CREATE DATABASE Syntax
CREATE DATABASE database_name;
DROP DATABASE Syntax
DROP DATABASE database_name;
USE Syntax
USE database_name;
CREATE TABLE Syntax
CREATE TABLE table_name (column1 datatype constraints, column2 datatype constraints, …);
DROP TABLE Syntax
DROP TABLE table_name;
TRUNCATE TABLE Syntax
TRUNCATE TABLE table_name;
ALTER TABLE ADD Syntax
ALTER TABLE table_name ADD column_name datatype constraints;
ALTER TABLE DROP COLUMN Syntax
ALTER TABLE table_name DROP COLUMN column_name;
ALTER TABLE MODIFY Syntax
ALTER TABLE table_name MODIFY COLUMN column_name new_datatype new_constraints;
ALTER TABLE RENAME COLUMN Syntax
ALTER TABLE table_name RENAME COLUMN old_name TO new_name;
ALTER TABLE ADD CONSTRAINT Syntax
ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint_type (column_name);
SELECT Basic Syntax
SELECT column1, column2 FROM table_name;
SELECT All Syntax
SELECT * FROM table_name;
SELECT with WHERE Syntax
SELECT column1, column2 FROM table_name WHERE condition;
SELECT with ORDER BY Syntax
SELECT column1 FROM table_name ORDER BY column1 ASC;
SELECT with LIMIT Syntax
SELECT column1 FROM table_name LIMIT n;
SELECT with DISTINCT Syntax
SELECT DISTINCT column1 FROM table_name;
SELECT with Alias Syntax
SELECT column1 AS alias_name FROM table_name AS t;
INSERT INTO Syntax
INSERT INTO table_name (column1, column2) VALUES (value1, value2);
INSERT Multiple Rows Syntax
INSERT INTO table_name (column1, column2) VALUES (val1, val2), (val3, val4);
UPDATE Syntax
UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
DELETE Syntax
DELETE FROM table_name WHERE condition;
CREATE INDEX Syntax
CREATE INDEX index_name ON table_name (column_name);
CREATE UNIQUE INDEX Syntax
CREATE UNIQUE INDEX index_name ON table_name (column_name);
DROP INDEX Syntax
DROP INDEX index_name ON table_name;
CREATE VIEW Syntax
CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition;
DROP VIEW Syntax
DROP VIEW view_name;
PRIMARY KEY in CREATE TABLE Syntax
column_name INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (column_name)
FOREIGN KEY in CREATE TABLE Syntax
FOREIGN KEY (column_name) REFERENCES other_table(other_column)
FOREIGN KEY ON DELETE CASCADE Syntax
FOREIGN KEY (column_name) REFERENCES other_table(other_column) ON DELETE CASCADE
CHECK Constraint Syntax
column_name datatype CHECK (column_name condition)
DEFAULT Constraint Syntax
column_name datatype DEFAULT default_value
INNER JOIN Syntax
SELECT a.col, b.col FROM tableA a INNER JOIN tableB b ON a.id = b.id;
LEFT JOIN Syntax
SELECT a.col, b.col FROM tableA a LEFT JOIN tableB b ON a.id = b.id;
RIGHT JOIN Syntax
SELECT a.col, b.col FROM tableA a RIGHT JOIN tableB b ON a.id = b.id;
FULL OUTER JOIN Simulated Syntax
SELECT * FROM tableA LEFT JOIN tableB ON tableA.id = tableB.id UNION SELECT * FROM tableA RIGHT JOIN tableB ON tableA.id = tableB.id;
CROSS JOIN Syntax
SELECT a.col, b.col FROM tableA a CROSS JOIN tableB b;
Self-Join Syntax
SELECT e1.name AS Employee, e2.name AS Manager FROM Employee e1 INNER JOIN Employee e2 ON e1.manager_id = e2.id;
GROUP BY Syntax
SELECT column1, COUNT(*) FROM table_name GROUP BY column1;
HAVING Syntax
SELECT column1, COUNT() FROM table_name GROUP BY column1 HAVING COUNT() > 5;
WHERE with LIKE Syntax
SELECT * FROM table_name WHERE column1 LIKE 'A%';
WHERE with IN Syntax
SELECT * FROM table_name WHERE column1 IN ('val1', 'val2', 'val3');
WHERE with BETWEEN Syntax
SELECT * FROM table_name WHERE column1 BETWEEN 10 AND 50;
WHERE with IS NULL Syntax
SELECT * FROM table_name WHERE column1 IS NULL;
Subquery in WHERE Syntax
SELECT * FROM table_name WHERE column1 = (SELECT MAX(column1) FROM table_name);
Subquery in FROM Syntax
SELECT sub.col FROM (SELECT column1 AS col FROM table_name) AS sub;
UNION Syntax
SELECT column1 FROM tableA UNION SELECT column1 FROM tableB;
UNION ALL Syntax
SELECT column1 FROM tableA UNION ALL SELECT column1 FROM tableB;
COUNT() Syntax
SELECT COUNT(*) FROM table_name;
COUNT(DISTINCT) Syntax
SELECT COUNT(DISTINCT column1) FROM table_name;
SUM() Syntax
SELECT SUM(column1) FROM table_name WHERE condition;
AVG() Syntax
SELECT AVG(column1) FROM table_name;
MIN() / MAX() Syntax
SELECT MIN(column1), MAX(column1) FROM table_name;
ROUND() Syntax
SELECT ROUND(column1, 2) FROM table_name;
CONCAT() Syntax
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM table_name;
CASE Expression Syntax
SELECT column1, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE default_result END AS alias FROM table_name;
IFNULL() Syntax
SELECT IFNULL(column1, 'Unknown') FROM table_name;
AUTO_INCREMENT Syntax
column_name INT NOT NULL AUTO_INCREMENT
GRANT Syntax
GRANT SELECT, INSERT ON database_name.table_name TO 'username'@'host';
REVOKE Syntax
REVOKE SELECT ON database_name.table_name FROM 'username'@'host';
CREATE USER Syntax
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
DROP USER Syntax
DROP USER 'username'@'host';
START TRANSACTION Syntax
START TRANSACTION;
COMMIT Syntax
COMMIT;
ROLLBACK Syntax
ROLLBACK;
SAVEPOINT Syntax
SAVEPOINT savepoint_name;
ROLLBACK TO Syntax
ROLLBACK TO savepoint_name;
SHOW DATABASES Syntax
SHOW DATABASES;
SHOW TABLES Syntax
SHOW TABLES;
DESCRIBE Syntax
DESCRIBE table_name;
SHOW CREATE TABLE Syntax
SHOW CREATE TABLE table_name;