create a test database
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 data
insert into test (x1,x2) values( "t1\nt2\nt3","x1\nx2\nx3");query results
select * from test;
+----+----------+----------+
| id | x1 | x2 |
+----+----------+----------+
| 1 | t1
t2
t3 | x1
x2
x3 |
+----+----------+----------+
1 row in set (0.00 sec)this result is too ugly, can it be displayed as follows?
+----+----------+----------+
| id | x1 | x2 |
+----+----------+----------+
| 1 | t1 | x1 |
| | t2 | x2 |
| | t3 | x3 |
+----+----------+----------+ x1 field is T1 carriage return T2 carriage return T3
x2 field x1 carriage return x2 carriage return x3