'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