sql:categories
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| sql:categories [2022/07/08 08:21] – 185.92.25.31 | sql:categories [2022/07/08 08:22] (current) – 185.92.25.31 | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| |DCL|Data Control Language| | |DCL|Data Control Language| | ||
| |TCL|Transaction 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 | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | |||
| - | ===== Examples ===== | ||
| - | |||
| - | ==== DDL ==== | ||
| - | |||
| - | === Create a table === | ||
| - | |||
| - | <code sql> | ||
| - | CREATE TABLE Students ( | ||
| - | rollno int PRIMARY KEY, | ||
| - | fname varchar (255) NOT NULL, | ||
| - | lname varchar (255) | ||
| - | ); | ||
| - | </ | ||
| ---- | ---- | ||
sql/categories.1657268490.txt.gz · Last modified: 2022/07/08 08:21 by 185.92.25.31