Databases
StackOverflow2013
Postsdbo
POImport CSV to MySQL
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POImport CSV to MySQL
    text
    copied!<p>I have created a database and a table. I have also created all the fields I will be needing. I have created 46 fields including one that is my ID for the row. The CSV doesn't contain the ID field, nor does it contain the headers for the columns. I am new to all of this but have been trying to figure this out. I'm not on here being lazy asking for the answer, but looking for directions.</p> <p>I'm trying to figure out how to import the CSV but have it start importing data starting at the 2nd field, since I'm hoping the auto_increment will fill in the ID field, which is the first field I created. </p> <p>I tried these instructions with no luck. Can anyone offer some insight? </p> <ol> <li>The column names of your CSV file must match those of your table</li> <li>Browse to your required .csv file</li> <li>Select CSV using LOAD DATA options</li> <li>Check box 'ON' for <em>Replace table data with file</em></li> <li>In <em>Fields terminated by</em> box, type <code>,</code></li> <li>In <em>Fields enclosed by</em> box, <code>"</code></li> <li>In <em>Fields escaped by</em> box, <code>\</code></li> <li>In <em>Lines terminated by</em> box, <code>auto</code></li> <li>In <em>Column names</em> box, type column name separated by <code>,</code> like <code>column1,column2,column3</code></li> <li>Check box ON for <em>Use LOCAL keyword</em>.</li> </ol> <p>Edit:</p> <p>The CSV file is 32.4kb </p> <p>The first row of my CSV is:</p> <pre><code>Test Advertiser,23906032166,119938,287898,,585639051,287898 - Engager - 300x250,88793551,Running,295046551,301624551,2/1/2010,8/2/2010,Active,,Guaranteed,Publisher test,Maintainer test,example-site.com,,All,All,,Interest: Dental; custom geo zones: City,300x250,-,CPM,$37.49 ,"4,415","3,246",3,0,$165.52 ,$121.69 ,"2,895",805,0,0,$30.18 ,$37.49 ,0,$0.00 ,IMPRESSIONBASED,NA,USD </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload