DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Vertical query results

Info Catalog (mysql.info.gz) mysql Tips (mysql.info.gz) mysql Tips (mysql.info.gz) safe-updates
 
 8.3.3.1 Displaying Query Results Vertically
 ...........................................
 
 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)
 
Info Catalog (mysql.info.gz) mysql Tips (mysql.info.gz) mysql Tips (mysql.info.gz) safe-updates
automatically generated byinfo2html