start transaction;

update `user` SET channel=substring(account_id, 1, 4),gameid=substring(account_id, 6, 4);

insert into version (version) values(2020112001);

commit;