Syntax\n------\n\nGOTO label\n\nDescription\n-----------\n\nThe GOTO statement causes the code to jump to the specified label, and continue operating from there. It is only accepted when in Oracle mode.\n\nExamples\n--------\n\nSET sql_mode=ORACLE;\n\nDELIMITER //\n\nCREATE OR REPLACE PROCEDURE p1 AS\n\nBEGIN\n\n  SELECT 1;\n  GOTO label;\n  SELECT 2;\n  <<label>>\n  SELECT 3;\n\nEND;\n\n//\n\nDELIMITER \n\nCALL p1();\n+---+\n| 1 |\n+---+\n| 1 |\n+---+\n1 row in set (0.000 sec)\n\n+---+\n| 3 |\n+---+\n| 3 |\n+---+\n1 row in set (0.000 sec)\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/programmatic-compound-statements/goto