mysql 中怎样补全相邻字段中的空值

Question

这张表是mysql 查询结果生成，怎样在这张表中将相邻左右值为1的，0值更新为1

Answer 1

update table set `2`=1 where `1`=1 and `3`=1
update table set `3`=1 where `2`=1 and `4`=1
update table set `4`=1 where `3`=1 and `5`=1
update table set `5`=1 where `4`=1 and `6`=1
update table set `6`=1 where `5`=1 and `7`=1
update table set `7`=1 where `6`=1 and `8`=1