100 quatloos to Chris for the simplest answer. Do that. I'll add that you could also use mysqldump:
mysqldump -T /tmp test users This would create /tmp/users.sql, containing the CREATE TABLE, and /tmp/users.txt, containing a tab-delimited file suitable for import. No header row, though. And, apparently, my perl solution completely reinvented the wheel. See pp.527-530 "MySQL Cookbook", 1st ed. for a better script. ____________________________________________________________ Eamon Daly ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 20, 2004 1:24 PM Subject: RE: Brainstorming' time! > Ok unless I missed something here, wouldn't you just use the "SELECT ... > INTO OUTFILE" Syntax found here > http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html > > Just search for "outfile" and you can find it faster. > > You can run a query against a table and save the output into a file and > in the case of creating excel type data, just save it into a file with > the fields separated by commas, a CSV file in other words. > > Then use excel to open the file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
