If you are running a script from the command line, try
mysql -BNe select 'some text to print'
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Friday, 25 August 2006 2:39 a.m.
To: Wai-Sun Chia; Dan Buettner
Cc: MySQL List
Subject: Re: Outputting text in a
You still get
On 8/24/06, Dan Buettner [EMAIL PROTECTED] wrote:
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 '';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-Original Message-
From: Stephen Cook [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 8:09 PM
Cc: Jesse; MySQL List
Subject: Re: Outputting text in a
There apparently isn't a PRINT or RAISERROR function like there is in
SQL Server, I've asked about this before.
I created
, August 24, 2006 2:14 AM
Subject: Re: Outputting text in a
On 8/24/06, Dan Buettner [EMAIL PROTECTED] wrote:
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 '';
--
MySQL General Mailing List
For list archives
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:http://lists.mysql.com/[EMAIL PROTECTED]
Sure - in your sql script, put in
SELECT text to the screen;
Dan
On 8/23/06, Jesse [EMAIL PROTECTED] wrote:
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:
There apparently isn't a PRINT or RAISERROR 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