LINUX下将mysql从5.1升级至5.5后,发现存储过程不能用了。创建和使用存储过程时就会提示Cannot load from mysql.proc. The table is probably corrupted。
查遍整个百度,结果还是印证了那一句话“天下文章一大抄”啊!
所有的文章几乎都是这么说的
解决方法非常简单,运行mysql_upgrade命令即可。此命令会在数据目录下生成一个文本文件mysql_upgrade_info,里面的内容为升级后的数据库版本。
但不知道什么原因,在我这里无效,升级后各种升级OK,但仍然报这个错误。
最后还是求助GOOGLE吧
http://bugs.mysql.com/bug.php?id=50183
原因是mysql.proc升级时有个字段没有升级成功。
在5.1中mysql.proc表的comment字段是varchar(64):
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
但在5.5中应该是text:
`comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
So,执行下面的语句,把这个字段修改为text,就彻底OK了:
ALTER TABLE `proc`
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `sql_mode`;
MODIFY COLUMN `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `sql_mode`;
相关推荐
proc.frm proc.MYD proc.MYI
select name,db from mysql.proc; delimiter $ DROP PROCEDURE p2$ CREATE PROCEDURE p2(in xname varchar(30),out xpassword varchar(50)) begin select password into xpassword from tb_users where name =...
The mission of this text is to provide you with a rock-solid foundation in the C# programming language and the core aspects of the .NET platform (assemblies, remoting, Windows Forms, Web Forms, ADO...
原版的oracle proc开发手册,英文书籍。 This chapter introduces you to the Pro*C/C Precompiler. You look at its role in developing application programs that manipulate Oracle data and find out what it ...
mysql 教程 里面有详细的mysql的语法和常用语句
一般产生原因是手工更改my.ini的数据库文件存放地址导致的,大家可以参考下下面的方法
SQL语句对单个的MySQL存储过程导出 首先确保参数secure-file-priv='' 表示不限制mysqld在任意目录...FROM MYSQL.PROC A WHERE A.NAME = PRO_NAME INTO OUTFILE "/HOME/MYSQL/PRO_NAME.SQL" FIELDS ESCAPED BY '';
oracle\proc学习资料 1.proc简介 2.proc程序的编写步骤 3.嵌入sql语句
1. 如果要求你在psinfo之外再实现另一个结点,具体内容自选,那么你会实现一个给出什么信息的结点 2. 一次read()未必能读出所有的数据,需要继续rea
The PT7314E is an audio processor designed for versatile application, including 4 stereo input selectors with adjustable gain, master volume control with low frequency loudness compensation, speaker ...
proc.rarproc.rarproc.rarproc.rar
7.3.1 How to Determine What the Current Thread is Executing . 94 7.3.2 Analyzing the Threads of the Program . . . . . 95 7.4 Familiarize Yourself with Threading Analysis Tools . . . . . 96 7.5 ...
将A数据的USERNAME用户的数据导出后,再导入到B数据库中的USERNAME时,在USERNAME用户下在执行表数据查询时出现如下问题: ORA-06550: 第 1 行, 第 7 列: PLS-00201: 必须声明标识符 ‘SYSTEM.PROC_AUDIT’ ORA-06550: ...
PChar类似于pathchar,试图通过沿一个终端到端到端路径表征互联网的带宽,时延,链路损耗。 它已经过测试各种版本的FreeBSD,NetBSD的,OpenBSD的,LINUX,Solaris和OSF / 1和IRIX,FreeBSD和Solaris。...
proc interface for the dasd driver.
mysql支持翻页与排序的存储过程,结合翻页功能和排序功能。
• Table of Contents • Index The Linux® Networking Architecture: Design and Implementation of Network Protocols in the Linux Kernel By Klaus Wehrle, Frank Pählke, Hartmut Ritter, Daniel Mü...
The book is especially of interest to those wishing to interact with ARTIK modules from within their own applications and web services. Table of Contents Chapter 1: Learning More About ARTIK Chapter...
一、简介 从 5.0 版本才开始支持,是一组为了完成特定功能的SQL语句集合(封装),比传统SQL速度更快、执行效率更高。 存储过程的优点 1、执行一次后,会将生成的二进制代码驻留缓冲区(便于下次执行),提高执行...
A total variability subspace is learned from the development set and is used to estimate a low (and fixed) dimensional latent factor called the identity vector (i-vector) from adapted mean ...