Export query to text file

2004-05-04 Thread Yingyos
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]

Re: Export query to text file

2004-05-04 Thread Yingyos
Victor Pendleton wrote: 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 fil

Re: Re: Export query to text file ***[SPAM]*** **SPAM HTMLM**

2004-05-05 Thread Yingyos
mysql> select date_format('2004-02-29','%X'); ++ | date_format('2004-02-29','%X') | ++ | 2004 | +--------+ 1 row in set (0.00 sec) How 's to do? Thank you for reply again, Y