Home | 簡體中文 | 繁體中文 | 雜文 | 打賞(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎專欄 | Search | Email

第 24 章 DDL - Data Definition Language

目錄

24.1. 資料庫管理(Database)
24.1.1. create
24.1.2. drop
24.1.3. Alter
24.1.4. Rename
24.1.5. CHARACTER
24.1.6. show create database
24.2. 表管理(Table)
24.2.1. 數據類型
24.2.1.1. SET 集合類型
24.2.2. create table ... select
24.2.3. modifiy table
24.2.4. TEMPORARY Table
24.2.5. Collate
24.2.6. CHARACTER
24.2.7. DEFAULT
24.2.7.1. AUTO_INCREMENT
24.2.7.2. 表存儲位置(DATA DIRECTORY)
24.2.8. KEY
24.2.8.1. PRIMARY KEY
24.2.9. COMMENT
24.2.10. Engine
24.2.10.1. FEDERATED
24.2.10.2. BLACKHOLE
24.3. Partitioning
24.3.1. RANGE
24.3.2. LIST
24.3.3. HASH
24.3.3.1. LINEAR HASH
24.3.4. KEY分區
24.3.5. Subpartitioning
24.3.6. 分區管理
24.3.6.1. 新增分區
24.3.6.2. 刪除分區
24.3.6.3. 重建分區
24.3.6.4. 分區維護
24.3.7. EXPLAIN PARTITIONS
24.3.8. SHOW CREATE TABLE
24.3.9. INFORMATION_SCHEMA.partitions 表
24.3.10. 分區數據操作
24.4. Index
24.4.1. SHOW INDEX
24.4.2. CREATE INDEX
24.4.3. DROP INDEX
24.4.4. rebuild
24.5. 外鍵(Foreign Key)
24.5.1. FOREIGN KEY (RESTRICT)
24.6. 視圖(View)
24.7. 存儲過程(PROCEDURE)
24.7.1. 存儲程序
24.7.2. 函數
24.8. 觸發器(Trigger)
24.8.1. create trigger
24.8.2. drop trigger
24.8.3. show triggers
24.8.4. EXAMPLE
24.8.4.1. BEFORE/AFTER
24.8.4.2. UUID
24.8.4.3. CALL PROCEDURE
24.9. 事件調度器(EVENT)
24.9.1. 啟用 EVENT
24.9.2. 創建 EVENT
24.9.3. 禁用/啟用
24.9.4. show events

24.1. 資料庫管理(Database)

24.1.1. create

Creating a UTF-8 database

CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
			

Create a UTF-8 database with binary UTF-8 collation.

CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_bin;
			

24.1.2. drop

DROP DATABASE db_name;
			

24.1.3. Alter

ALTER DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
			

24.1.4. Rename

RENAME {DATABASE | SCHEMA} db_name TO new_db_name;
			

before 5.0 version

[neo@development ~]$ mysqldump -uroot -pchen db_old | mysql -uroot -pchen db_new
			

24.1.5. CHARACTER

			
ALTER DATABASE <database_name> CHARACTER SET utf8;
			
			

24.1.6. show create database

			
mysql> show create database dbname;
+----------+-------------------------------------------------------------------+
| Database | Create Database                                                   |
+----------+-------------------------------------------------------------------+
| dbname   | CREATE DATABASE `dbname` /*!40100 DEFAULT CHARACTER SET utf8 */   |
+----------+-------------------------------------------------------------------+
1 row in set (0.00 sec)