| 1 |
SHOW DATABASES; |
| 2 |
CREATE DATABASE; |
| 3 |
USE database_name; |
| 4 |
SOURCE <path_of_.sql_file>; |
| 5 |
DROP DATABASE database_name; |
| 6 |
SHOW TABLES; |
| 7 |
CREATE TABLE <table_name1> (<col_name1> <col_type1>, <col_name2> <col_type2>, PRIMARY KEY (<col_name1>), FOREIGN KEY (<col_name2>) REFERENCES <table_name2>(<col_name2>)); |
| 8 |
CREATE TABLE instructor (ID CHAR(5), name VARCHAR(20) NOT NULL, dept_name VARCHAR(20), PRIMARY KEY (ID), FOREIGN KEY (dept_name) REFERENCES department(dept_name)); |
| 9 |
INSERT INTO <table_name> (<col_name1>, <col_name2>, <col_name3>) VALUES (<value1>, <value2>, <value3>); |
| 10 |
INSERT INTO <table_name> VALUES (<value1>, <value2>, <value3>); |
| 11 |
UPDATE <table_name> SET <col_name1> = <value1>, <col_name2> = <value2> WHERE <condition>; |
| 12 |
DELETE FROM <table_name>; |
| 13 |
SELECT col_name1, col_name2 FROM table_name; |
| 14 |
SELECT * FROM table_name; |
| 15 |
SELECT DISTINCT col_name1, col_name2 FROM table_name; |
| 16 |
SELECT col_name1, col_name2 FROM table_name WHERE condition; |
Комментарии