title: Mysql query vertical "\G" not working
body: <p>I have a question about query data with vertical format, I tried it with \g or \G . </p>
  
  <p>I referenced "4.5.1.6.2 Displaying Query Results Vertically" at <a href="https://dev.mysql.com/doc/refman/5.5/en/mysql-tips.html" rel="nofollow">https://dev.mysql.com/doc/refman/5.5/en/mysql-tips.html</a></p>
  
  <p>But it not working and show error syntax at "\G"</p>
  
  <p>My query : </p>
  
  <pre><code>select * from mytable \G . Always wrong.
  </code></pre>
  
  <p>From that, I just want to build final query like this:</p>
  
  <pre><code>Select "A","B","C","D" as "ColumnName" \G
  </code></pre>
  
  <p>Expect:</p>
  
  <pre><code>ColumnName    
  A    
  B    
  C    
  D
  </code></pre>
  
  <p>I tried with UNION or UNION ALL. but with several thousand record, it's slow performance.</p>
  
  <p>And mysql version is : Server version- 5.6.17 - MySQL Community Server (GPL)</p>
  
  <p>@ Bernd Buffen</p>
  
  <p>I show my query:</p>
  
  <pre><code>Select C.* from 
  
  (
  
    (  Select * from (Select "Value1" as newcolumn UNION ALL Select "Value2" as newcolumn UNION ALL ...&lt;200.000 UNION ALL&gt;)   ) A
  
  left join  
  
  (SELECT key,column1,column2,colum3 FROM supplier ) B
  
  on A.newcolumn = B.key 
  
  ) C
  </code></pre>
  
  <p>And handle query to database, I debug time from Begin to End, it spend from 1.30 to 2 minutes. It is not good.</p>