List:General Discussion« Previous MessageNext Message »
From:Mark Leith Date:August 2 2005 2:20pm
Subject:RE: STORED PROCEDURE
View as plain text  
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
 

Thread
STORED PROCEDUREScott Hamm2 Aug
  • RE: STORED PROCEDUREMark Leith2 Aug
    • Re: STORED PROCEDUREScott Hamm2 Aug
      • RE: STORED PROCEDUREMark Leith2 Aug
        • RE: STORED PROCEDUREMark Leith2 Aug
          • Re: STORED PROCEDUREMartijn Tonies2 Aug
        • Re: STORED PROCEDUREScott Hamm2 Aug
  • Re: STORED PROCEDURESGreen2 Aug
    • Re: STORED PROCEDUREScott Hamm2 Aug