title: MySQL: Loading multiple files into a table
body: <p>I've been trying to load multiple files into a table, so that they would fit the same row. </p>
  
  <p>I can insert them separately, but then the issue lies within the <code>NULL</code> values, and I plan to JOIN this table. If that happens, I get too many <code>NULL</code> values -- useless data. </p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'malefirst.txt, femalefirst.txt, allfirst.txt, allfirst.txt' 
  INTO TABLE fnames 
   (mal, fml, unk, cpx);
  </code></pre>
  
  <p>Another thing I have actually looked into was joining the files together with </p>
  
  <pre><code>paste -d " " (1.txt 2.txt ....)
  </code></pre>
  
  <p>However, it turned into a mess. If the first method does not work, then I can use the second, but I will need advice on it as well.</p>