stored procedures - MySQL Error - understanding it -

stored procedures - MySQL Error - understanding it -

has seen sort of error , means?

i have stored procedure running cursor through 502 records , passes through loop, inserts table, in essence re-create , paste entering 239 of these records , error

1265 info truncated column 'v_tagmembersf' @ row 5 1265 info truncated column 'v_tagmembersf' @ row 6 1265 info truncated column 'v_tagmembersf' @ row 7 1265 info truncated column 'v_tagmembersf' @ row 10 1265 info truncated column 'v_tagmembersf' @ row 11 1265 info truncated column 'v_tagmembersf' @ row 12 1265 info truncated column 'v_tagmembersf' @ row 13 1265 info truncated column 'v_tagmembersf' @ row 14

the stored procedure cursor

open cur1; -- start loop -- datasetloop: loop -- values of each column our variables declared in stored procedure fetch cur1 v_datetime, v_val, v_numindex, v_tagname, v_tagindex, v_tagmembersf, v_tagmemberminval, v_tagmembermaxval; if v_tagmembersf = null set v_tagmembersf = 1; end if; -- check if v_val null first -- insert new_tempdata.looper (incremented, tagnameinserted) values (v_datetime, v_tagname); commit; if done leave datasetloop; end if; end loop datasetloop; close cur1; insert new_tempdata.looper (incremented, tagnameinserted) values (123456789,'id29sp'); end

does have thought might doing?

this error mean new_tempdata.looper table cant store info trying insert. check length of fields incremented , tagnameinserted, must same v_datetime & v_tagname;

mysql stored-procedures insert cursor truncate