![]() Originally, I tried to keep this short but somebody wanted an example in a loop. SELECT 'CALL hello_world' AS "Statement" Reset the delimiter to write a procedure. ![]() SELECT 'DROP PROCEDURE hello_world' AS "Statement" SELECT 'CALL hello _world' AS "Statement" CALL hello_world ( ) Reset the delimiter back to a semicolon to work again.ĭELIMITER - Call the procedure. ![]() CREATE PROCEDURE hello_world ( ) BEGIN - Print the phrase and a line return. SELECT 'DROP PROCEDURE hello _world' AS "Statement" DROP PROCEDURE IF EXISTS hello_world - Reset the delimiter to write a procedure.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |