import multiple table data into mysql using single csv file

Question

I have this table in csv file

enter image description here

Now i have two mysql tables dealing with this csv file,

Data A, B, C has to get stored in Table1 whereas data D, E, F, G, H has to get stored in Table2.

I have the above formatted csv file, how can i upload its data to MYSQL database??

So that from same file input can be done for different tables.

Copy paste into Google docs and do this: blog.pamelafox.org/2009/05/… :) — Robin Castlin
– Robin Castlin, Commented Apr 4, 2012 at 8:54
If you are looking at doing it with the LOAD DATA INFILE SQL command, you can have a look at this article: blog.terresquall.com/2022/05/… — John Doe
– John Doe, Commented May 10, 2022 at 1:46

user652792 · Accepted Answer · 2012-04-04 11:22:30Z

1

Try this it's working well, you can add as many values as possible depending on the number of columns you have in the CSV file.

  <?php   

 $fname = $_FILES['csv_file']['name'];     
  $chk_ext = explode(".",$fname);             

        $filename = $_FILES['csv_file']['tmp_      name'];   
 $handle = fopen($filename, "r");      
 if(!$handle){
 die ('Cannot open file for reading');
  }      
              while (($data = fgetcsv($handle,      10000, ",")) !== FALSE)
 {
          $query = "INSERT INTO tablename        (col1_csv, col2_csv)
 values ('$data[0]', '$data[1]');
   mysql_query($query) 
   or die(mysql_error());


        $query1 = "INSERT INTO tablename        (col1_csv, col2_csv)
    values ('$data[0]', '$data[1]');
   mysql_query($query1) 
 or die(mysql_error());
 }
 fclose($handle);
  ?>

answered Apr 4, 2012 at 11:22

user652792

Sign up to request clarification or add additional context in comments.

Comments

Zathrus Writer · Accepted Answer · 2012-04-04 08:43:11Z

1

Probably only via custom script (PHP or so)...

But it's usually not hard to split CSV into 2 files and import both into separate tables using LOAD_DATA function from MySQL directly. It will be MUCH faster than using phpMyAdmin or similar scripts.

answered Apr 4, 2012 at 8:43

Zathrus Writer

4,3315 gold badges30 silver badges53 bronze badges

Comments

ragingasiancoder · Accepted Answer · 2016-07-01 13:40:05Z

0

Load the data in a temporary table, then split up in two tables.

Then drop that temporary table. I somewhere read that php can do this, but I cannot help in php codes.

edited Jul 1, 2016 at 13:40

ragingasiancoder

6006 silver badges17 bronze badges

answered Apr 4, 2012 at 8:50

Ankit Sharma

4,0792 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

import multiple table data into mysql using single csv file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related