On Sun, Sep 25, 2005 at 03:56:46PM -0500, Peter Brawley wrote:
> Jim,
>
> If you really want to return the result in a variable, declare a user
> var in the client, declare an OUT var in the SP, have the SP SELECT INTO
> it, and pass the user var to the SP in the call:
>
> SET @x=0;
> SET GLOBAL log_bin_trust_routine_creators = TRUE;
> DROP PROCEDURE IF EXISTS CountPhoneNumbers;
> DELIMITER |
> CREATE PROCEDURE CountPhoneNumbers ( OUT count INT )
> BEGIN
> SELECT COUNT(*) INTO count
> FROM customer
> WHERE Phone IS NOT NULL;
> END;
> |
> DELIMITER ;
> CALL CountPhoneNumbers(@x);
> SELECT @x;
>
Thanks Peter,
Since she was teaching us about using a variable I am trying your second
example.
Thanks again,
Jim Seymour
--
I started using something better than the "standard" back when IBM advertised
OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux.
You don't have to accept less than you deserve.
"Use the Power of the Penguin" Registered Linux user #316735
