title: select into outfile : Headers not on top
body: <p>I have done</p>
  
  <pre><code>select 'Header1', 'Header2'...
  union all
  select * from TABLE where $conditions
  into outfile 'c:/users/sf/desktop/output.csv'
  fields terminated by ';'
  lines terminated by '\n'
  </code></pre>
  
  <p>The problem is: The headers are not on top but almost at the bottom. Version is 10.1.34-MariaDB.</p>
  
  <p>What am I doing wrong?</p>