Yingyos <[EMAIL PROTECTED]> wrote:
>
> I type this command line.
>
> mysql -uuser -N -e"select date_format('2004-02-29','%X')" > sample2.txt
>
> When i open in text editor,it show that '2004' only.
>
> But i want format display on text file.
>
> mysql> select date_format('2004-02-29','%X');
>
#x27;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 r
ingyos Santipasert
Victor Pendleton wrote:
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 que
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 wrot
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
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.
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 res
