# 數據庫與表顯示、創建、刪除 ## 數據庫顯示 > **show databases;** ``` mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | app_blogcurder | | auth_demo | | canzhieps | | cmsdemo | | mysql | | onethink | | performance_schema | | ranzhi | | thinkems | | thinksns_3_1 | | thinksns_4_0 | +--------------------+ 12 rows in set (0.01 sec) ``` ## 創建數據庫 > **create database 庫名字;** ``` mysql> create database test; Query OK, 1 row affected (0.00 sec) ``` ## 刪除數據庫 > **drop database [IF EXISTS] 庫名字;** ``` mysql> drop database test; Query OK, 0 rows affected (0.01 sec) ``` ## 選中數據庫 >[success] **use 庫名;** ``` mysql> use mysql Database changed mysql> \s -------------- mysql Ver 14.14 Distrib 5.6.17, for Win64 (x86_64) Connection id: 8 Current database: mysql Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.6.17 MySQL Community Server (GPL) ``` ## 顯示表 ### 數據表 > **show tables;**[需要縣選中數據庫] ``` mysql> use mysql Database changed mysql> show tables; +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | event | | func | | general_log | ... ... ``` ### 顯示表結構 > **desc 表名; 或者 describe 表名;** ``` mysql> desc db; +-----------------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------+------+-----+---------+-------+ | Host | char(60) | NO | PRI | | | | Db | char(64) | NO | PRI | | | | User | char(16) | NO | PRI | | | ... ... ``` ## 表創建 ``` CREATE TABLE `member` ( `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用戶ID', `nickname` char(16) NOT NULL DEFAULT '' COMMENT '昵稱', `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性別', `birthday` date NOT NULL DEFAULT '0000-00-00' COMMENT '生日', `qq` char(10) NOT NULL DEFAULT '' COMMENT 'qq號', `score` mediumint(8) NOT NULL DEFAULT '0' COMMENT '用戶積分', `login` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登錄次數', `reg_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '注冊IP', `reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注冊時間', `last_login_ip` bigint(20) NOT NULL DEFAULT '0' COMMENT '最后登錄IP', `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登錄時間', `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '會員狀態', PRIMARY KEY (`uid`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='會員表'; ``` ## 表刪除 > **drop table 表名;**