'How can I create a stored procedure in MySql?
I'm trying to create a stored procedure but i have an error: "Statement is uncomplete, expecting ";"
use kms;
create procedure getAllClients()
BEGIN
select * from Clients;
END;
Solution 1:[1]
Try this
use kms;
DELIMITER //
create procedure getAllClients()
BEGIN
select * from Clients;
END//
DELIMITER ;
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Kathi Kellenberger |
