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

第 23 章 DDL - Data Definition Language

目錄

23.1. 資料庫管理(Database)
23.1.1. create
23.1.2. drop
23.1.3. Alter
23.1.4. Rename
23.1.5. CHARACTER
23.1.6. show create database
23.2. 表管理(Table)
23.2.1. 數據類型
23.2.1.1. SET 集合類型
23.2.2. create table ... select
23.2.3. modifiy table
23.2.4. TEMPORARY Table
23.2.5. Collate
23.2.6. CHARACTER
23.2.7. DEFAULT
23.2.7.1. AUTO_INCREMENT
23.2.7.2. 表存儲位置(DATA DIRECTORY)
23.2.8. KEY
23.2.8.1. PRIMARY KEY
23.2.9. COMMENT
23.2.10. Engine
23.2.10.1. FEDERATED
23.2.10.2. BLACKHOLE
23.3. Partitioning
23.3.1. RANGE
23.3.2. LIST
23.3.3. HASH
23.3.3.1. LINEAR HASH
23.3.4. KEY分區
23.3.5. Subpartitioning
23.3.6. 分區管理
23.3.6.1. 新增分區
23.3.6.2. 刪除分區
23.3.6.3. 重建分區
23.3.6.4. 分區維護
23.3.7. EXPLAIN PARTITIONS
23.3.8. SHOW CREATE TABLE
23.3.9. INFORMATION_SCHEMA.partitions 表
23.3.10. 分區數據操作
23.4. Index
23.4.1. SHOW INDEX
23.4.2. CREATE INDEX
23.4.3. DROP INDEX
23.4.4. rebuild
23.5. 外鍵(Foreign Key)
23.5.1. FOREIGN KEY (RESTRICT)
23.6. 視圖(View)
23.7. 存儲過程(PROCEDURE)
23.7.1. 存儲程序
23.7.2. 函數
23.8. 觸發器(Trigger)
23.8.1. create trigger
23.8.2. drop trigger
23.8.3. show triggers
23.8.4. EXAMPLE
23.8.4.1. BEFORE/AFTER
23.8.4.2. UUID
23.8.4.3. CALL PROCEDURE
23.9. 事件調度器(EVENT)
23.9.1. 啟用 EVENT
23.9.2. 創建 EVENT
23.9.3. 禁用/啟用
23.9.4. show events

23.1. 資料庫管理(Database)

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

23.1.2. drop

DROP DATABASE db_name;
			

23.1.3. Alter

ALTER DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
			

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

23.1.5. CHARACTER

			
ALTER DATABASE <database_name> CHARACTER SET utf8;
			
			

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