title: Add blank row to MySQL query results based upon change in column value
body: <p>If I have a typical MySQL query such as:</p>
  
  <pre><code>SELECT CommentNo, CreatedDate, CreatedTime, Text FROM Comment
  </code></pre>
  
  <p>The results will be displayed in a simple table. But is it possible to have MySQL format the output so that a blank line can be inserted into the results based upon a change in a column?</p>
  
  <p>So if my query above returns the following by default:</p>
  
  <pre><code> CommentNo CreatedDate CreatedTime Text
   1         2012-08-02  15:33:27    This.
   2         2012-08-02  15:34:40    That.
   3         2013-06-30  19:45:48    Something else.
   4         2013-06-30  21:26:01    Nothing.
   5         2013-06-30  21:26:43    Was.
   6         2013-07-01  13:40:32    Hello.
   7         2013-07-01  14:08:25    Goodbye.
  </code></pre>
  
  <p>Is it possible to insert a blank row upon change of column value for <code>CreatedDate</code>, so I get:</p>
  
  <pre><code> CommentNo CreatedDate CreatedTime Text
   1         2012-08-02  15:33:27    This.
   2         2012-08-02  15:34:40    That.
  
   3         2013-06-30  19:45:48    Something else.
   4         2013-06-30  21:26:01    Nothing.
   5         2013-06-30  21:26:43    Was.
  
   6         2013-07-01  13:40:32    Hello.
   7         2013-07-01  14:08:25    Goodbye.  
  </code></pre>
  
  <p>The above is not how data would be stored in the Comment table, it is an issue of formatting query output.</p>
  
  <p>Or would it be better to use a <code>BufferedWriter</code> in Java?</p>