on 3/13/01 12:41 AM, Gilles Dumangin at [EMAIL PROTECTED] wrote:
> I would like to extract the contents of a database to use it in a ASCII
> format. It is a addresses database and I want to use it in Excel. I have
> tried Mysqldump but it gives me the CREATE and INSERT statements all the
> time.
SELECT ... INTO OUTFILE <path to nonexistent file on server>
Will put the data into the file specified in a tab seperated text format.
There are other options detailed in the manual.
Bear in mind that the file is placed on the server, not the client, and that
mysqld must have write permission on the directory you're putting it in.
Hope this helps,
Geoff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
