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

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

 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 | |+------------+----------+------+-----+---------+----------------+

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

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

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

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

 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)

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