使用\G按行垂直显示结果
在SQL语句或者命令后使用\G而不是分号结尾,可以将每一行的值垂直输出
mysql> show create table log \G
*************************** 1. row ***************************
Table: log
Create Table: CREATE TABLE `log` (
`logId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uName` varchar(255) NOT NULL,
`logIp` varchar(255) NOT NULL,
`logTime` datetime NOT NULL,
`handout` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '电子讲义 0:无讲义,1:有讲义。默认为0',
PRIMARY KEY (`logId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql>
注:\g的作用和sql语句后面的分号类似,水平显示查询数据
mysql> show create table log \g
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| log | CREATE TABLE `log` (
`logId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uName` varchar(255) NOT NULL,
`logIp` varchar(255) NOT NULL,
`logTime` datetime NOT NULL,
`handout` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '电子讲义 0:无讲义,1:有讲义。默认为0',
PRIMARY KEY (`logId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>