import a csv file into multiple mysql tables

mustlovechocolate · #1 (**permalink**) 02-28-09, 01:57

Is there any way that I can import one .csv file and then distribute its contents into multiple tables?

guelphdad · #2 (**permalink**) 02-28-09, 20:09

create a temporary table, import your csv there and then update the multiple tables from that.

mustlovechocolate · #3 (**permalink**) 03-02-09, 03:57

Will try that and tell you if I succeed..

mike_bike_kite · #4 (**permalink**) 03-02-09, 07:30

Quote:

Will try that and tell you if I succeed

You didn't provide any feedback on your previous thread regarding malnourished children.

mustlovechocolate · #5 (**permalink**) 03-02-09, 23:28

here's the thing, my csv file has around 150++ columns which would be divided into around 30 tables in mysql..

i need to use a browse button in the site to import the csv file into mysql..

i have no idea how i'm going to do it..

sorry, its really my first time to use mysql and php...

mike_bike_kite · #6 (**permalink**) 03-03-09, 04:07

Quote:

Originally Posted by mustlovechocolate

here's the thing, my csv file has around 150++ columns which would be divided into around 30 tables in mysql..

i need to use a browse button in the site to import the csv file into mysql..

i have no idea how i'm going to do it..

You could just set up a "transfer" table with those 150 columns. Then load the CSV data directly into this table and then process the data from there.

Then for each of the tables in your database that gets it's data from the CSV file you could just insert any new records that appear in the transfer table that you don't already have. You'll probably want to do an update to existing data if their fields have changed.

Quote:

Originally Posted by mustlovechocolate

sorry, its really my first time to use mysql and php