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