distinct 数据库 去重
DDL语句 数据库定义语言
数据定义语句 定义了不同数据段,数据库,表,索引,列等数据库对象
常用 create drop alter等
一般数据库管理员使用 (DBA )
操作数据库内部对象
DML 操作数据库内部数据 curd
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| banma2 |
| mysql |
| performance_schema |
| sys |
| test |
| zysshop |
+--------------------+
7 rows in set (0.04 sec)
mysql> USE TEST;
Database changed
mysql> SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| courses |
| tablaname |
| tablename2 |
| test |
+----------------+
4 rows in set (0.04 sec)
mysql> USE TEST;
Database changed
mysql> DESC TEST;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | NO | PRI | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.04 sec)
mysql> SHOW CREATE TABLE test;
+-------+------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------