bitscn.com
mysql创建存储过程失败1307错误解决
本人在创建存储过程的时候出现错误码: 1307 failed to create procedure
mysql创建存储过程失败错误，经查资料实践后整理得出是mysql本身的问题,解决办法:
先将phpmyadmin中的mysql数据库中的表proc删除
然后执行以下代码重建该表,经测试成功.
java代码
create table `proc` (
`db` char(64) character set utf8 collate utf8_bin not null default '',
`name` char(64) not null default '',
`type` enum('function','procedure') not null,
`specific_name` char(64) not null default '',
`language` enum('sql') not null default 'sql',
`sql_data_access` enum('contains_sql','no_sql','reads_sql_data',
'modifies_sql_data') not null
default 'contains_sql',
`is_deterministic` 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 '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_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'
注意：在删除proc表之前最好先把查询窗口弹出，不然你删除proc表
中没发通过sql创建改表
bitscn.com