From Transact-SQL Help file:
Returns a user-defined message to the client.
PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr
'any ASCII text'
Is a string of text.
Is a variable of any valid character data type. @local_variable must be char or varchar,
or be able to be implicitly converted to those data types.
Is a function that returns string results. @@FUNCTION must be char or varchar, or be able
to be implicitly converted to those data types.
Is an expression that returns a string. Can include concatenated literal values and
variables. The message string can be up to 8,000 characters long; any characters after
8,000 are truncated.
From: Rhino [mailto:rhino1@stripped]
Sent: Thursday, 11 May 2006 3:51 p.m.
To: Stephen Cook
Cc: MySQL List
Subject: Re: PRINT statement?
I am not familiar with the PRINT command so I don't know what it does. I
played with MS SQL Server once for a couple of days a few years back and
that is the only contact I've ever had with SQL Server.
If you can tell me what PRINT does, in detail, maybe I can suggest another
----- Original Message -----
From: "Stephen Cook" <sclists@stripped>
To: "Rhino" <rhino1@stripped>
Cc: "MySQL List" <mysql@stripped>
Sent: Wednesday, May 10, 2006 8:09 PM
Subject: Re: PRINT statement?
> I've started using the SELECT with no other clauses but I am still curious
> about a PRINT-like command. It is for SQL scripts.
> Rhino wrote:
>> ----- Original Message ----- From: "Stephen Cook" <sclists@stripped>
>> To: "MySQL List" <mysql@stripped>
>> Sent: Sunday, May 07, 2006 3:53 AM
>> Subject: PRINT statement?
>>> Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)?
>>> It would be handy to debug some scripts.
>> If you're talking about a script that is running SQL, you can simply use
>> the SELECT statement without any FROM, WHERE, ORDER BY, GROUP BY or
>> HAVING clauses. For example:
>> select "Creating Foo table" as "Action";
>> will produce the following output:
>> | Action |
>> | Creating Foo table |
>> 1 row in set (0.00 sec)
>> If you're talking about an OS script, you can use OS commands to display
>> things. For example, I have some BASH scripts on our Linux server so I
>> can use the BASH echo command, like this:
>> echo "Report Date:" $report_date;
>> to produce this output:
>> Report Date: Sun May 7 09:42:57 EDT 2006
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 09/05/2006
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 09/05/2006
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If received in error you are asked to destroy this email
and contact the sender immediately. Your assistance is appreciated.