CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title = '%Unconditional%';
SELECT title;
END;
//
mysql> CALL title()//
+-----------------+
| title |
+-----------------+
| %Unconditional% |
+-----------------+
1 row in set (0.01 sec)
HTH
Mark
Mark Leith
Cool-Tools UK Limited
http://www.cool-tools.co.uk
> -----Original Message-----
> From: Scott Hamm [mailto:linuxgold@stripped]
> Sent: 02 August 2005 15:12
> To: 'Mysql '
> Subject: STORED PROCEDURE
>
> I'm used with MS SQL and could not understand MySQL's
> document. I'm trying to create something like the simple example
>
> DECLARE @title varchar(255)
> SET @title='%Unconditional%'
> SELECT @title;
>
> How do I get around to it in MySQL?
>
> --
> Power to people, Linux is here.
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date:
> 01/08/2005
>
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 01/08/2005
