Hi Brian, All, On Sun, Nov 30, 2008 at 8:56 PM, Brian Aker <[EMAIL PROTECTED]> wrote: > Is there any advantage in CSV having delete or update? Truncate I > understand....
Would be nice to have, but indeed - not essential. I would much rather have a clean way to overwrite the datafile with new contents, and/or to point an existing CSV file to another data file. kind regards, Roland > > Cheers, > --Brian > > On Nov 30, 2008, at 10:33 AM, "Roland Bouman" <[EMAIL PROTECTED]> > wrote: > >> Hi All, >> >>> Any more comments or suggestions? >> >> Yeah - What about extending CSV engine to support user defined >> delimiters and such in the DDL? The reason why I like this feature is >> that for ETL jobs, you can use this to kind of simulate a stream of >> data. The disadvantage of LOAD DATA INFILE is that you waste time on >> loading and storing data in a table (which is a pity if the table is >> not the final destination and you need to process the data before >> storing it) >> >> Of course, a storage engine is just an implementation - something like: >> >> SELECT ... >> FROM LOAD DATA INFILE .. etc >> >> would be ok too (perhaps even more powerful) >> >>> >>> Thanks! >>> >>> -Brian >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~drizzle-discuss >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> >> -- >> Roland Bouman >> http://rpbouman.blogspot.com/ > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
