Mysql stored procedure creation failed 1307 error resolved _ MySQL

Mysql stored procedure creation failed 1307 error solved bitsCN.com

Mysql storage creation failed 1307 error solved

When I create a stored PROCEDURE, I see "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.

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,

'Specpacific _ 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,

'Returns' 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_pISION_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: Before deleting a proc table, you 'd better bring up the query window. Otherwise, you can delete the proc table.
The table is not created through SQL.

BitsCN.com