Need to delete MySQL database under proc table in recreate create table ' proc ' (' db ' char () Character set UTF8 collate utf8_bin not NULL default ' ', ' nam E ' char (+) NOT null default ' ', ' type ' enum (' FUNCTION ', ' PROCEDURE ') is not null, ' Specific_name ' char (+) ' NOT NULL default ', ' Language ' enum (' SQL ') not NULL default ' sql ', ' sql_data_access ' enum (' Contains_sql ', ' no_sql ', ' reads_sql_data ', ' MO Difies_sql_data ') NOT null default ' Contains_sql ', ' is_deterministic ' enum (' YES ', ' no ') is not null default ' No ', ' secur Ity_type ' enum (' INVOKER ', ' definer ') not null default ' Definer ', ' param_list ' blob is not NULL, ' returns ' char (+) NOT NULL Default ', ' body ' longblob not NULL, ' Definer ' char (character set UTF8 collate utf8_bin NOT null default ' ', ' crea Ted ' timestamp not null default Current_timestamp in Updatecurrent_timestamp, ' modified ' timestamp not NULL default ' 0000 -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 ') is not NULL default ' ', ' comment ' char (+) Character Set UT F8 collate utf8_bin not NULL default ' ', ' character_set_client ' char (+) Character Set UTF8 collate utf8_bin default NULL , ' collation_connection ' char (+) Character Set UTF8 collate utf8_bin default NULL, ' Db_collation ' char (+) character SE T UTF8 collate utf8_bin default NULL, ' Body_utf8 ' Longblob, PRIMARY KEY (' db ', ' name ', ' type ')) default Charset=utf8 COM Ment= ' Stored procedures '
Http://www.2cto.com/database/201305/209107.html
Zhuanzai
1307 error occurred in creating stored procedure in MySQL, workaround