LOAD DATA INFILE to load data into different tables
<p>I have two tables:</p>

<pre><code>Company(id int, varchar(name), primary key(id));
Product (id int, c_id int, varchar(name), foreign key(c_id), references Company(id));
</code></pre>

<p>Table 'Company' stores a list of company names and 'Product' stores a list of product names, and one company can have multiple products.</p>

<p>If I have data file like this, tab delimited:</p>

<pre><code>1  Apple  iPhone
2  Apple  iPad
3  Apple  iMac
4  Google Gmail
5  Google Google Search
6  Amazon Kindle
</code></pre>

<p>Is it possible to use "Load DATA INFILE" to load this file into two tables, where the first column goes to table Company and second coloumn goes to Product? The question is how to load selected fields to a particular table, instead of loading the full record into one table.</p>