romulo1405241517 0 Report post Posted February 1, 2006 (edited) Interesting Things to Know about MySQL ! Some query results are much more readable when displayed vertically, instead of in the usual horizontal table format. Queries can be displayed vertically by terminating the query with \G instead of a semicolon. For example, longer text values that include newlines often are much easier to read with vertical output: mysql> SELECT * FROM mails WHERE LENGTH(txt) < 300 LIMIT 300,1\G *************************** 1. row *************************** msg_nro: 3068 date: 2000-03-01 23:29:50 time_zone: +0200 mail_from: Monty reply: monty@no.spam.com mail_to: "Thimble Smith" <tim@no.spam.com> sbj: UTF-8 txt: >>>>> "Thimble" == Thimble Smith writes: Thimble> Hi. I think this is a good idea. Is anyone familiar Thimble> with UTF-8 or Unicode? Otherwise, I'll put this on my Thimble> TODO list and see what happens. Yes, please do that. Regards, Monty file: inbox-jani-1 hash: 190402944 1 row in set (0.09 sec) -----Copied from http://www.advogato.org/person/robhudson/-----szupie Edited February 2, 2006 by szupie (see edit history) Share this post Link to post Share on other sites
Hercco 0 Report post Posted February 1, 2006 Neat!I'm not totally unfamiliar with databases having studied everything my university has to offer regarding them but I didn't know that. Granted, I don't use mysql much from the command line but anyways this is cool thing to know. Share this post Link to post Share on other sites
