drop table if exists t1;create table t1 (col1 integer primary key, col2 integer) engine=innodb;insert t1 values (1,100);create function f1 () returns integer begindeclare var1 int;select col2 into var1 from t1 where col1=1 for update;return var1;end|start transaction;select f1();f1()100