sql:cheat_sheet:categories
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| sql:cheat_sheet:categories [2022/07/08 07:46] – 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 | ||
| - | </ | ||
| - | |||
sql/cheat_sheet/categories.1657266392.txt.gz · Last modified: 2022/07/08 07:46 by 185.92.25.31