add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id user_id
1 11
2 12
3 13
4 14
5 15
6 16
7 17
8 18
9 19
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 UPDATE u null index null PRIMARY 8 null 9 100.00 Using where
3 DEPENDENT SUBQUERY users_ids_mapping null eq_ref current_user_id current_user_id 9 fiddle_PZIAQDTCPDICWUPOUJCC.u.user_id 1 100.00 null
2 DEPENDENT SUBQUERY users_ids_mapping null eq_ref current_user_id current_user_id 9 fiddle_PZIAQDTCPDICWUPOUJCC.u.user_id 1 100.00 null
id user_id
4 14
5 15
6 16
7 17
8 18
9 19
1 21
2 22
3 23
id user_id
5 15
8 18
9 19
1 21
2 22
3 23
4 24
6 26
7 27
id user_id
5 15
1 21
2 22
3 23
4 24
6 26
7 27
8 28
9 29