[snip] IS it possible to export a query from mysql in a specific format. I created a query- SELECT id,title,class,grade FROM semester1; \T semester1 but it exported the query in a table form.
Can anyone tell me if you can export the query in another format----Tab delimited,cvs etc. [/snip] from http://www.mysql.com/doc/S/E/SELECT.html SELECT stuff INTO OUTFILE "/tmp/result.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM test_table; This will generate a CSV file HTH! Jay --------------------------------------------------------------------- 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