I've had occasions, in previous jobs, where being able to use INTO OUTFILE has saved a tremendous amount of time and pain. Not only can you specify the format of the output (field separators, etc), but you can also selectively retrieve only certain rows (rather than the entire table) by using a WHERE clause. Any replacement should offer the same type of functionality IMHO.
-Dave On Oct 19, 2011, at 1:16 PM, Henrik Ingo wrote: > It's good to have input from several end users. In your case, would > something like "mysqldump --tab tablename > outfile.csv" work? > > henrik > > On Wed, Oct 19, 2011 at 7:27 PM, Tim Soderstrom > <[email protected]> wrote: >> For what it's worth, we use SELECT … INTO OUTFILE for a number of small >> reports which end up going out over e-mail. It's a lo-fi solution but that's >> all that was desired at the time, and this feature meant it only took a few >> minutes to setup. I'm not really in favor one way or another, but just >> voicing our use case as this is a feature we currently use, regularly, on >> MySQL. >> >> On Oct 14, 2011, at 11:38 AM, Brian Aker wrote: >> >>> I don't believe it really is within our current scope. That being said, I >>> don't believe it does much harm either. >>> >>> Sent from my C64 >>> >>> On Oct 14, 2011, at 3:14 AM, Olaf van der Spek <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> Drizzle still appears to support "select into outfile". At least >>>> there's code for it. Is still still supported? >>>> Shouldn't this be done client-side? IMO this server-side code should be >>>> removed. >>>> >>>> See for example drizzled\file_exchange.h >>>> >>>> -- >>>> Olaf >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~drizzle-discuss >>>> Post to : [email protected] >>>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>>> More help : https://help.launchpad.net/ListHelp >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~drizzle-discuss >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp >> > > > > -- > [email protected] > +358-40-8211286 skype: henrik.ingo irc: hingo > www.openlife.cc > > My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
