The `INTO OUTFILE` clause is expecting a table reference. An alternatvie is mysql -uuser -N -e"select now()" > sample2.txt
-----Original Message----- From: Yingyos To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 5/4/04 2:20 AM Subject: Export query to text file Hi, I have MySQL 4.0.17 on Windows XP. I use SELECT ... INTO OUTFILE print out query to text file. If i write this command. mysql>SELECT * from tbl1 INTO OUTFILE "C:\\Query\\sample1.txt"; MySQL reponse OK.But i change command. mysql>SELECT now() INTO OUTFILE "C:\\Query\\sample2.txt"; MySQL response by exit from console. How's to use SELECT ... INTO OUTFILE with datetime or another function. Thank for the reply, Yingyos Santiprasert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
