On Fri, Nov 28, 2008 at 2:37 PM, Brian Aker <[EMAIL PROTECTED]> wrote: > What is the current thinking for LOAD DATA LOCAL INFILE? > > I have heard plenty of complaints about the "LOCAL" version, but I can not > say I have ever understood why they exist.
having a way to load a file of data from the client in a fairly generic way is important. the non-LOCAL version of 'load data' has never been that useful to me in mysql because of the permissions (or just having the data on the wrong machine) issues. but the implementation of 'load data local' is not great, particularly in the way that the protocol is used to tell the client to send a file. in general, i prefer the syntax of LOAD DATA to remembering a bunch of fiddly switches to something like mysqlimport, but that may just be me. that mysqlimport can't do any of the data manipulation during load that you can now do with LOAD DATA makes it even less useful. jim _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
