Data Warehousing Community Forum
February 10, 2012, 01:04:52 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: LOAD LOCAL DATA INFILE and LOAD DATA INFILE?  (Read 4341 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: July 03, 2008, 11:39:17 am »
Frndz,

Is there any significance difference between LOAD LOCAL DATA INFILE and LOAD DATA INFILE?
Logged
Sipra
Founder

www.dwforum.net
ragjeevan
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 15


View Profile WWW
« Reply #1 on: February 19, 2010, 03:39:35 pm »
LOAD DATA LOCAL INFILE will read a file that is on the machine where you are
running the mysql client. For eg., your Laptop.The file willbe sent
over the network to the MySQL server host.

LOAD DATA INFILE will read a file that is already present on the machine running the
mysql server.
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: