Mysqldump will write out all the SQL needed to build the table (in plain text form).
Connecting with the client and doing a select * from table will also "write out the table in plain text form" Finally doing a select into outfile (see manual for syntax details) will also "write out the table in plain text form" -----Original Message----- From: Jinghua Tang [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:32 AM To: [EMAIL PROTECTED] Subject: write out tables It is a newbie question. I am wondering if there is a way to write out a table in plain text form. Thank you in advance! Jinghua <<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>>< Jinghua Tang, Ph.D. Phone: 858-784-8647(o) Department of Molecular Biology, MB-31 858-268-9321(h) The Scripps Research Institute Fax: 858-784-8660 10550 North Torrey Pines Road E-mail: [EMAIL PROTECTED] La Jolla, CA 92037 http://www.scripps.edu/~jinghua <<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>><<>>< --------------------------------------------------------------------- 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