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

第 11 章 DDL - Data Definition Language

目錄

11.1. 資料庫管理(Database)
11.1.1. create
11.1.2. drop
11.1.3. Alter
11.1.4. Rename
11.1.5. CHARACTER
11.1.6. show create database
11.2. 表管理(Table)
11.2.1. 數據類型
11.2.1.1. SET 集合類型
11.2.2. create table ... select
11.2.3. modifiy table
11.2.4. TEMPORARY Table
11.2.5. Collate
11.2.6. CHARACTER
11.2.7. DEFAULT
11.2.7.1. AUTO_INCREMENT
11.2.7.2. 表存儲位置(DATA DIRECTORY)
11.2.8. KEY
11.2.8.1. PRIMARY KEY
11.2.9. COMMENT
11.2.10. Engine
11.2.10.1. FEDERATED
11.2.10.2. BLACKHOLE
11.3. Partitioning
11.3.1. RANGE
11.3.2. LIST
11.3.3. HASH
11.3.3.1. LINEAR HASH
11.3.4. KEY分區
11.3.5. Subpartitioning
11.3.6. 分區管理
11.3.6.1. 新增分區
11.3.6.2. 刪除分區
11.3.6.3. 重建分區
11.3.6.4. 分區維護
11.3.7. EXPLAIN PARTITIONS
11.3.8. SHOW CREATE TABLE
11.3.9. INFORMATION_SCHEMA.partitions 表
11.3.10. 分區數據操作
11.4. Index
11.4.1. SHOW INDEX
11.4.2. CREATE INDEX
11.4.3. DROP INDEX
11.4.4. rebuild
11.5. 外鍵(Foreign Key)
11.5.1. FOREIGN KEY (RESTRICT)
11.6. 視圖(View)
11.7. 存儲過程(PROCEDURE)
11.7.1. 存儲程序
11.7.2. 函數
11.8. 觸發器(Trigger)
11.8.1. create trigger
11.8.2. drop trigger
11.8.3. show triggers
11.8.4. EXAMPLE
11.8.4.1. BEFORE/AFTER
11.8.4.2. UUID
11.8.4.3. CALL PROCEDURE
11.9. 事件調度器(EVENT)
11.9.1. 啟用 EVENT
11.9.2. 創建 EVENT
11.9.3. 禁用/啟用
11.9.4. show events

11.1. 資料庫管理(Database)

11.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;
			

11.1.2. drop

DROP DATABASE db_name;
			

11.1.3. Alter

ALTER DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
			

11.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
			

11.1.5. CHARACTER

			
ALTER DATABASE <database_name> CHARACTER SET utf8;
			
			

11.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)