mysql中提供了一个G [g] 标志,放到sql语句后,可以使一行的每个列打印到单独的行。例如:
mysql> select * from user_msg limit 2\G;
*************************** 1. row ***************************
uid: 1
today_msg: 0
today_recv: 1
recvmsgcount: 59
sendmsgcount: 0
twoday1: 0
treeday1: 0
towday2: 0
treeday2: 0
todayfist: 0
*************************** 2. row ***************************
uid: 2
today_msg: 0
today_recv: 1
recvmsgcount: 292
sendmsgcount: 2693
twoday1: 0
treeday1: 0
towday2: 0
treeday2: 0
todayfist: 0
2 rows in set (0.02 sec)
mysql> select * from user_msg limit 2\G;
*************************** 1. row ***************************
uid: 1
today_msg: 0
today_recv: 1
recvmsgcount: 59
sendmsgcount: 0
twoday1: 0
treeday1: 0
towday2: 0
treeday2: 0
todayfist: 0
*************************** 2. row ***************************
uid: 2
today_msg: 0
today_recv: 1
recvmsgcount: 292
sendmsgcount: 2693
twoday1: 0
treeday1: 0
towday2: 0
treeday2: 0
todayfist: 0
2 rows in set (0.02 sec)