Jump to content

Load data infile


kolobok

Recommended Posts

Hello guys

 

 

MySQL

 

Server: Localhost via UNIX socket

Server version: 5.1.46-1

Protocol version: 10

MySQL charset: UTF-8 Unicode (utf8)

Web server

 

nginx/0.7.67

MySQL client version: 5.0.51a

PHP extension: mysqli

 

Epty InnoDB latin1_swedish_ci

 

Task is to load data from CSV file in to multiple tables updating fk and filtering duplicates.

EX

 

 

I was looking in to load  LOAD DATA INFILE but I am not shure...

 

 

I will appreciate any input of the solution or point in to the example.

 

Thank you

 

 

 

[attachment deleted by admin]

Link to comment
https://forums.phpfreaks.com/topic/241256-load-data-infile/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.