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

以你之姓@ 2022-01-12 14:55 208阅读 0赞

**1.导入数据  
  command:  
SOURCE <PATH> <data.sql>;  
 eg:  
mysql> source ~/MyDoc/create.sql;  
  
  
  
2.SHOW COLUMNS FROM <table\_name>的快捷方式为DESCRIBE <table\_name>  
 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 <database\_name>;  
 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 <database\_name>;  
 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；**