Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
Home Help Search Login Register
*
Welcome, Guest. Please login or register.
Did you miss your activation email? 		July 31, 2010, 02:35:22 am


Login with username, password and session length


Data Warehousing Community Forum > Databases > Microsoft SQL Server > Topic: LOAD LOCAL DATA INFILE and LOAD DATA INFILE?
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: LOAD LOCAL DATA INFILE and LOAD DATA INFILE?  (Read 1227 times)
Sipra
Founder
*****

Reputation: +35/-0
Offline Offline

Posts: 232


I 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  
Data Warehousing Community Forum > Databases > Microsoft SQL Server > Topic: LOAD LOCAL DATA INFILE and LOAD DATA INFILE?
 « previous next »
 
Jump to:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM