mysql 结果比较好_怎样更好的显示mysql的select结果？

创建测试数据库

CREATE TABLE `test` (

-> `id` int(2) unsigned NOT NULL AUTO_INCREMENT,

-> `x1` varchar(20) NOT NULL ,

-> `x2` varchar(20) NOT NULL ,

-> PRIMARY KEY (`id`)

-> ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;

插入数据

insert into test (x1,x2) values( "t1\nt2\nt3","x1\nx2\nx3");

查询结果

select * from test;

+----+----------+----------+

| id | x1 | x2 |

+----+----------+----------+

| 1 | t1

t2

t3 | x1

x2

x3 |

+----+----------+----------+

1 row in set (0.00 sec)

这个结果太难看了，可否显示成下面的模样？

+----+----------+----------+

| id | x1 | x2 |

+----+----------+----------+

| 1 | t1 | x1 |

| | t2 | x2 |

| | t3 | x3 |

+----+----------+----------+

x1字段的值就是 t1 回车 t2 回车 t3

x2字段的值就是 x1 回车 x2 回车 x3