tir, 12,.04.2005 kl. 01.04 -0400, skrev kalin mintchev: > > hi all... > > > is there a simple way to export data from mysql tables? like the opposite > of 'load data infile'? i was looking around in the manual but without > success...
SELECT * from table_name into outfile '/tmp/whatever'; Jarle -- Jarle Aase email: [EMAIL PROTECTED] Author of freeware. http://www.jgaa.com news:alt.comp.jgaa War FTP Daemon: http://www.warftp.org War FTP Daemon FAQ: http://www.warftp.org/faq/warfaq.htm Jgaa's PGP key: http://war.jgaa.com/pgp NB: If you reply to this message, please include all relevant information from the conversation in your reply. Thanks. <<< no need to argue - just kill'em all! >>> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]