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