Just starting with MySQL, create a test stored procedure testproc in MySQL Workbench with the following code:
Create PROCEDURE TestProc ()
Begin
Show variables like '%per_table ';
End
Direct Ctrl+shift+enter execution, prompt:
11:00:33 Create PROCEDURE TestProc () Begin Show variables like '%per_table ' Error code:1064. You have a error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near "at line 3 0.000 sec
It seems to see, also did not find grammatical errors ah, strange weird, find data toss a half-day, the original MySQL default statement ending sign is a semicolon, and the stored procedure SQL once used a semicolon to think that the sentence ended, so the stored procedure is incomplete, the execution of the prompt above the syntax error. The workaround is also simple, use delimiter//statement to set the MySQL terminator to//, and finally use delimiter; Change the closing symbol back to the original semicolon and execute the code as follows:
Delimiter//
Create PROCEDURE TestProc ()
Begin
Show variables like '%per_table ';
End//
delimiter;