mysql -uuser -N -e"select date_format('2004-02-29','%X')" > sample2.txt
-----Original Message-----
From: Yingyos
To: Victor Pendleton
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 5/4/04 11:04 PM
Subject: Re: Export query to text file
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 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
>
>
>
>
>
>
>
>
Hi Victor Pendleton ,
I want format on text file .
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,
Yingyos Santipasert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]