MySQL学习足迹记录01--SOURCE，SHOW

1.导入数据

 command: SOURCE  ; eg: mysql> source ~/MyDoc/create.sql;

2.SHOW COLUMNS FROM 的快捷方式为DESCRIBE

 eg: mysql> SHOW COLUMNS FROM orders;+------------+----------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+------------+----------+------+-----+---------+----------------+| order_num | int(11) | NO | PRI | NULL | auto_increment || order_date | datetime | NO | | NULL | || cust_id | int(11) | NO | MUL | NULL | |+------------+----------+------+-----+---------+----------------+mysql> DESCRIBE orders;+------------+----------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+------------+----------+------+-----+---------+----------------+| order_num | int(11) | NO | PRI | NULL | auto_increment || order_date | datetime | NO | | NULL | || cust_id | int(11) | NO | MUL | NULL | |+------------+----------+------+-----+---------+----------------+

3.显示服务器状态信息

 command: SHOW STATUS; eg: mysql> SHOW STATUS;+------------------------------------------+-------------+| Variable_name | Value |+------------------------------------------+-------------+| Aborted_clients | 0 || Aborted_connects | 0 | ......... .........

4.显示授予用户

 command: SHOW GRANTS; eg: mysql> SHOW GRANTS;+----------------------------------------------------------------------------------------------------------------------------------------+| Grants for root@localhost ....... .......

5.显示错误信息

 command: SHOW ERRORS; eg: mysql> SHOW ERRORS;+-------+------+----------------------------------------------------------------------------------------------------------------------------------------------------+| Level | Code | Message ....... .......

6.显示警告信息

 command: SHOW WARMMINGS; eg: mysql> SHOW WARMMINGS;ERROR 10 (42000): You have an error in your SQL syntax; ....... .......

7.显示创建特定数据库的语句

 command: SHOW CREATE DATABASE ; eg: mysql> SHOW CREATE DATABASE MySQL_ex;+----------+---------------------------------------------------------------------+| Database | Create Database |+----------+---------------------------------------------------------------------+| MySQL_ex | CREATE DATABASE `MySQL_ex` /*!40100 DEFAULT CHARACTER SET latin1 */ |+----------+---------------------------------------------------------------------+1 row in set (0.00 sec)

8.显示创建特定表格的语句

 command: SHOW CREATE TABLE ; eg: mysql> SHOW CREATE TABLE orders;+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| Table | Create Table |+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| orders | CREATE TABLE `orders` ( `order_num` int(11) NOT NULL AUTO_INCREMENT, `order_date` datetime NOT NULL, `cust_id` int(11) NOT NULL, PRIMARY KEY (`order_num`), KEY `fk_orders_customers` (`cust_id`), CONSTRAINT `fk_orders_customers` FOREIGN KEY (`cust_id`) REFERENCES `customers` (`cust_id`)) ENGINE=InnoDB AUTO_INCREMENT=20010 DEFAULT CHARSET=latin1 | ....

9.其他SHOW命令

HELP SHOW；