Results 1 to 3 of 3
Thread: Testing a Stored Procedure
Feb 5, 2011, 14:45 #1
- Join Date
- Apr 2010
- 0 Post(s)
- 0 Thread(s)
Testing a Stored Procedure
If I have a Stored Procedure like this...
DELIMITER $$ CREATE PROCEDURE select_customer(type VARCHAR(10)) BEGIN IF cust_type = 'premium' THEN SELECT * FROM customers WHERE type = 'premium'; ELSE SELECT * FROM customers; END IF; END$$ DELIMITER;
Shouldn't I be able to test the Stored Procedure with a call like this??