MySQL でクエリを分割せずに Error 1093 を回避するには?

create table t1(
id    int,
value int);

delete from t1;
insert into t1 values
(1, 0),
(2, 1),
(3, 1),
(4, 4),
(5, 3),
(6, 2),
(7, 3),
(8, 2),
(9, 1);

update t1,(SELECT MAX(a.id) as tid
             FROM t1 a
            WHERE id < 6 AND value <= 2) as b
set value = value+1
where tid < id
  and id < 6;

UPDATE t1, (SELECT MAX(id) as tid
              FROM t1
             WHERE (id < 6)
               AND (value <= (SELECT value
                                FROM t1
                               WHERE id = 6))) as t2
   SET value = value + 1
 WHERE (tid < id)
   AND (id < 6);

create table t1 (
    pkey int auto_increment primary key,
    id int,
    value int,
    …(ノードの属性が複数)…);