Is it possible to output text to the screen from a .sql script? If so, how?
Thanks,
Jesse

Sure - in your sql script, put in
SELECT "text to the screen";
Dan
8/23/06, Jesse <jlc (AT) msdlg (DOT) comwrote:
Is it possible to output text to the screen from a .sql script? If so, how?
Thanks,
Jesse

There apparently isn't a PRINT or RAISERRR function like there is in
SQL Server, I've asked about this before.

I created a stored procedure to dump debug text into a table (which is
timestamped) and another to output the rows in there in a SELECT. It
isn't the same but it's something.

Dan Buettner wrote:
Sure - in your sql script, put in
SELECT "text to the screen";

Dan

8/23/06, Jesse <jlc (AT) msdlg (DOT) comwrote:
>Is it possible to output text to the screen from a .sql script? If
>so, how?
>>
>Thanks,
>Jesse
>>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>@gmail.com
>>
>>

8/24/06, Dan Buettner <drbuettner (AT) gmail (DOT) comwrote:
Sure - in your sql script, put in
SELECT "text to the screen";
Then you'll get 2 copies
Try this:
SELECT "text to the screen" AS '';

You still get two lines, it's just that one of the lines is blank, and the
other says, "text to the screen".

Jesse
Message
From: "Wai-Sun Chia" <waisun.chia (AT) gmail (DOT) com>
To: "Dan Buettner" <drbuettner (AT) gmail (DOT) com>
Cc: "Jesse" <jlc (AT) msdlg (DOT) com>; "MySQL List" <mysql (AT) lists (DOT) mysql.com>
Sent: Thursday, August 24, 2006 2:14 AM
Subject: Re: text in a

8/24/06, Dan Buettner <drbuettner (AT) gmail (DOT) comwrote:
>Sure - in your sql script, put in
>SELECT "text to the screen";
>
Then you'll get 2 copies
Try this:
SELECT "text to the screen" AS '';