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:[EMAIL PROTECTED] > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
