I can't seem to execute the following create procedure in the SQL Editor.
DELIMITER ;;
CREATE PROCEDURE `GetAllPhoneBook`()
BEGIN
START TRANSACTION;
SELECT * FROM phone_book;
COMMIT;
END;;
DELIMITER ;
I got the following error:
22:21:44 Kernel error: Error( 1064 ) 42000: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DELIMITER ;;