sql:cheat_sheet:categories
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| sql:cheat_sheet:categories [2022/07/08 07:49] – 185.92.25.31 | sql:cheat_sheet:categories [2022/07/08 08:07] (current) – removed 185.92.25.31 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== SQL - Cheat Sheet - Categories ====== | ||
| - | |||
| - | |DDL|Data Definition Language| | ||
| - | |DQL|Data Query Language| | ||
| - | |DML|Data Manipulation Language| | ||
| - | |DCL|Data Control Language| | ||
| - | |TCL|Transaction Control Language| | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ===== Commands ===== | ||
| - | |||
| - | ==== DDL ==== | ||
| - | |||
| - | <code sql> | ||
| - | CREATE | DROP | ALTER | TRUNCATE | RENAME | COMMENT | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== DQL ==== | ||
| - | |||
| - | <code sql> | ||
| - | SELECT | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== DML ==== | ||
| - | |||
| - | <code sql> | ||
| - | INSERT | UPDATE | DELETE | LOCK | CALL | EXPLAIN PLAIN | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== DCL ==== | ||
| - | |||
| - | <code sql> | ||
| - | GRANT | REVOKE | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== TCL ==== | ||
| - | |||
| - | <code sql> | ||
| - | COMMIT | ROLLBACK | SAVEPOINT | SET TRANSACTION | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ===== Examples ===== | ||
| - | |||
| - | ==== DDL ==== | ||
| - | |||
| - | === Create a table === | ||
| - | |||
| - | <code sql> | ||
| - | CREATE TABLE Students ( | ||
| - | rollno int PRIMARY KEY, | ||
| - | fname varchar (255) NOT NULL, | ||
| - | lname varchar (255) | ||
| - | ); | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
sql/cheat_sheet/categories.1657266591.txt.gz · Last modified: 2022/07/08 07:49 by 185.92.25.31