日期:2014-05-16  浏览次数:20796 次

MySQL错误:Out of range value adjusted for column ...

写Mysql存储过程时碰见了这样的错误:Out of range value adjusted for column ... ,经查证出现这样的错是由于不同类型的变量之间赋值产生的,如:

DECLARE  id_  bigint;
DECLARE  dbName_  varchar(400);
SET id_ = 1000;
SET dbName_ = ‘dbName’;
SELECT id_ INTO dbName_;//将可能会出错

?

?