Re: how to execute a procedure

[Jay Alverson]

If I understand you, you need to change the DELIMITER

The following is an example of a simple stored procedure that uses an OUT
parameter. The example uses the mysql client delimiter command to change the
statement delimiter from ; to // while the procedure is being defined. This
allows the ; delimiter used in the procedure body to be passed through to the
server rather than being interpreted by mysql itself. 


mysql> delimiter //

mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
    -> BEGIN
    ->   SELECT COUNT(*) INTO param1 FROM t;
    -> END;
    -> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

Is that what you mean ?

>

Thanks, Jay