批量取后10位替换之前为"XXX":
update `book` set reservation_no = concat('XXX', right(book_no, 10));
批量替换前5位为"XXX":
update `reservation` set reservation_no = concat('SHSW', substr(reservation_no, 5));
批量取后10位替换之前为"XXX":
update `book` set reservation_no = concat('XXX', right(book_no, 10));
批量替换前5位为"XXX":
update `reservation` set reservation_no = concat('SHSW', substr(reservation_no, 5));