MySQL异常:Out of range value adjusted for column .

MySQL错误:Out of range value adjusted for column ...写Mysql存储过程时碰见了这样的错误:Out of range

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_;//将可能会出错

?

?