有時文字模式下存取 MySQL 資料庫,如果資料是很長的話,往往輸出的結果會很凌亂。要解決這個問題,只要在 SQL 語句後面加上 "\G" 便可解決,例如原本是寫成這樣的 SQL 語句:
select * from user;
改成
select * from user\G;
4wei July 5th, 2006 at 16:13
謝謝大大提供這麼實用的方式 ^^
Name (required)
Mail (will not be published) (required)
Website
Anti-spam word: (Required)* To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.