A 1307 error occurred while creating the mysql storage process.

The create procedure proc1 (OUT s int) process in mysql is simple, but the 1307 error occurs during the import process, let's take a look at the solution to this problem.

Test

The Code is as follows:	Copy code
Create procedure test1 (in a int) // create; procedure stored procedure () Begin // start Select * from test where id = a; // here is the statement of the stored procedure End; // end // Note: Delimiter must be changed //

If the database is successfully created, it indicates that there is no problem with the database and the stored procedure can be created normally, but a problem occurs during the import.

A 1307 error occurred during creation and the cause of the problem was not found. After searching on the internet, I found that there is a simple method to solve this problem by recreating the proc table.

Specifically, you can use phpmyadmin to delete the proc table, execute the SQL statement to recreate the table, and then restart mysql to take effect.