Mysql stored PROCEDURE creation Failed 1307 error solved when I created the stored PROCEDURE "error code: 1307 Failed to CREATE PROCEDURE
An error occurred while creating the storage process for mysql. After checking the information and practices, the problem was resolved by mysql. solution: delete the table proc in the mysql database in phpmyadmin and run the following code to recreate the table. The test is successful. java code create table 'proc' ('db' char (64) character set utf8 collate utf8_bin not null default '', 'name' char (64) not null default '', 'type' enum ('function', 'processed') not null, 'specific _ name' char (64) not null default '', 'language' enum ('SQL ') not null default 'SQL', 'SQL _ data_access' enum ('ins INS _ SQL ', 'no _ SQL', 'reads _ SQL _DATA ',
'Modifies _ SQL _DATA ') not null default 'ins INS _ SQL', 'is _ terministic 'enum ('yes', 'no') NOT NULL default 'no ', 'Security _ type' enum ('invoker ', 'definer') not null default 'definer', 'Param _ list' blob not null, 'returs' char (64) not null default '', 'body' longblob not null, 'definer' char (77) character set utf8 collate utf8_bin not null default '', 'created 'timestamp not null default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP, 'modified' timestamp not null default '2017-00-00 00:00:00 ',' SQL _ mode' set ('real _ AS_FLOAT ', 'pipes _ as_concat ', 'ansi _ QUOTES ', 'ignore _ space ',
'Not _ used', 'only _ FULL_GROUP_BY ', 'no _ UNSIGNED_SUBTRACTION', 'no _ DIR_IN_CREATE ', 'postgresql ',
'Oracle ', 'mssql', 'db2', 'maxdb', 'no _ K EY_OPTIONS ', 'no _ TABLE_OPTIONS', 'no _ FIELD_OPTIONS ', 'gbase80 ',
'Gbase81 ', 'ansi', 'no _ AUTO_VALUE_ON _ ZERO ', 'no _ BACKSLASH_ESCAPES', 'strict _ TRANS_TABLES ', 'strict _
ALL_TABLES ', 'no _ ZERO_IN_DATE', 'no _ ZE RO_DATE ', 'invalid _ dates', 'error _ FOR_DIVISION_BY_ZERO', 'traditional ',
'No _ AUTO_CREATE_USER ', 'high _ NOT_PRECEDENCE') not null default '', 'comment' char (64) character set utf8 collate utf8_bin not null default '', 'character _ set_client 'char (32) character set utf8 collate utf8_bin default NULL, 'collation _ connection' char (32) character set utf8 collate utf8_bin default NULL, 'db _ collation' char (32) character set utf8 collate utf8_bin default NULL, 'body _ utf8' longblob, primary key ('db', 'name', 'type ')) default charset = utf8 COMMENT = 'stored Procedures 'Note: it is best to bring up the query window before deleting the proc table. Otherwise, you can delete the proc table.
The table is not created through SQL.