原因是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
原版的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 ...
proc.rarproc.rarproc.rarproc.rar
mysql支持翻页与排序的存储过程,结合翻页功能和排序功能。
根据表查询条件自动生成insert into sql语句,支持where条件,支持表各种类型字段。打印出来的字符不会被截断。sp执行完后,直接copy出来就可以在ms sql里执行。
mysql 教程 里面有详细的mysql的语法和常用语句
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 ...
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...
Table of Contents Foreword 1. Acknowledgements 2. Nota Bene 1. Introduction 1.1. What Is A Kernel Module? 1.2. How Do Modules Get Into The Kernel? 2. Hello World 2.1. Hello, World (part 1): The ...
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 '';
• 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ü...
oracle\proc学习资料 1.proc简介 2.proc程序的编写步骤 3.嵌入sql语句
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 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...
数据库本科作业数据库编程 --1、创建一个名为“PROC_系部读者借阅信息”的无参存储过程,要求...FROM tb_borrow,tb_reader WHERE tb_borrow.rno=tb_reader.rno and borrow>'2009-1-1' END exec PROC_系部读者借阅信息
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 ...
Eavesdropping: It is easy for eavesdroppers to get the signal from the open wireless circumstance, which lead to leak the business information. Dos attack: An attacker transmits some messages to ...
Linux System Administrator Guide Version0.9 <br>Table of Contents About This Book....................................................................................................................
proc interface for the dasd driver.
usbnet.c,the driver of usb2net,add proc.