Check out select into outfile. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL ECT
Ryan ----- Original Message ----- From: "Cindy Yu" <[EMAIL PROTECTED]> I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will create a file on your server. What is the equivalent command for Mysql. For example: sqlplus> Spool C:\temp\table_names sqlplus> select table_name from user_tables; sqlplus> spool off; This will create a file on the server. Cindy --------------------------------------------------------------------- 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