>From Transact-SQL Help file: PRINT
Returns a user-defined message to the client. Syntax PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr Arguments 'any ASCII text' Is a string of text. @local_variable 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. @@FUNCTION Is a function that returns string results. @@FUNCTION must be char or varchar, or be able to be implicitly converted to those data types. string_expr 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. -----Original Message----- From: Rhino [mailto:[EMAIL PROTECTED] 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 alternative. -- Rhino ----- Original Message ----- From: "Stephen Cook" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Cc: "MySQL List" <mysql@lists.mysql.com> 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" <[EMAIL PROTECTED]> >> To: "MySQL List" <mysql@lists.mysql.com> >> 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: >> >> #!/bin/bash >> report_date=`/bin/date` >> echo "Report Date:" $report_date; >> >> to produce this output: >> >> Report Date: Sun May 7 09:42:57 EDT 2006 >> >> >> -- >> Rhino >> >> >> >> > > > -- > 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/[EMAIL PROTECTED] 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
