Fw: Print file
Christo, Thursday, February 07, 2002, 11:52:06 AM, you wrote: CR Hi all CR How can I take info from one table and print it into a txt file. CR the table is (NAME) CR and all the names in it I want to print out to a file name virtusertable. See info about mysqldump: http://www.mysql.com/doc/m/y/mysqldump.html You can also use SELECT ... INTO OUTFILE statement, look at: http://www.mysql.com/doc/S/E/SELECT.html CR Thanx CR Christo -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Print file
Hi Christo, 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. Would SELECT ... INTO OUTFILE 'file_name' suit you? (MySQL manual: 6.4.1 SELECT Syntax) Regards, =dn - 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
Re: Print file
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 databasenamevirtusertable.sqlvirtusertable.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 - 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
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
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
Re: Print file
Hi Christo, 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. Would SELECT ... INTO OUTFILE 'file_name' suit you? (MySQL manual: 6.4.1 SELECT Syntax) Regards, =dn - 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
Re: Print file
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 databasenamevirtusertable.sqlvirtusertable.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
Fw: Print file
Christo, Thursday, February 07, 2002, 11:52:06 AM, you wrote: CR Hi all CR How can I take info from one table and print it into a txt file. CR the table is (NAME) CR and all the names in it I want to print out to a file name virtusertable. See info about mysqldump: http://www.mysql.com/doc/m/y/mysqldump.html You can also use SELECT ... INTO OUTFILE statement, look at: http://www.mysql.com/doc/S/E/SELECT.html CR Thanx CR Christo -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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