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]
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
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