1307 error occurred creating MySQL stored procedure

Let's test it.

The code is as follows	Copy Code
CREATE PROCEDURE test1 (in a int)//create creation; procedure stored procedure; test1 is stored procedure name or any parameter must be added () Begin//Start SELECT * FROM Test where id=a;//here is the statement of the stored procedure end;//End Note: Create with MySQL must change delimiter to//

The creation of a successful, representative of the database is no problem to create a stored procedure, but the problem occurred in the import, and then the following Baidu

A 1307 error occurred while creating, and the cause of the problem has not been found. Search on the internet for a while, found that there is a simple way to proc table can be rebuilt to solve.

The specific is to use phpMyAdmin to remove the proc table, and then in the execution of SQL rebuild this table, and then restart MySQL can take effect.