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

页面导航:首页 > 数据库 > Mysql > MySQL学习足迹记录01--SOURCE,SHOW

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

来源: 作者: 时间:2016-02-18 10:28 【

MySQL学习足迹记录01--SOURCE,SHOW1.导入数据 command: SOURCE PATH data.sql; eg: mysql source ~/MyDoc/create.sql;2.SHOW COLUMNS FROM table_name的快捷方式为DESCRIBE tabl...
MySQL学习足迹记录01--SOURCE,SHOW
 
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 [email protected]  
  
 .......
 .......

 

 
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:
     > 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;
     
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<