Christo: Write a query that does what you want to a text file called virtusertable.sql: USE databasename; SELECT name FROM tablename;
Then run the query from the command line (mysql -uusername -p databasename<virtusertable.sql>virtusertable.txt) Gerald Jensen ----- Original Message ----- From: "Christo Rademeyer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 3:52 AM Subject: Fw: Print file Hi all How can I take info from one table and print it into a txt file. the table is (NAME) and all the names in it I want to print out to a file name virtusertable. Thanx Christo sql,query --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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