欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2024-04-03 22:01:40
...
bitsCN.com

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

bitsCN.com
相关标签: command 记录