mysql,impala十进制转二进制

update music.class_record set tag_bit=LPAD(bin(cast(tag_bit as bigint)),32,‘0’) where length(tag_bit)!=32;
update music.class_room set status_bit=LPAD(bin(cast(status_bit as bigint)),32,‘0’) where length(status_bit)!=32;
update music.user set status_bit=LPAD(bin(cast(status_bit as bigint)),16,‘0’) where length(status_bit)!=16;
update music.user_public_info set status_bit=LPAD(bin(cast(status_bit as bigint)),8,‘0’) where length(status_bit)!=8;
update music.teacher_info set time_bit=LPAD(bin(cast(time_bit as bigint)),64,‘0’) where length(time_bit)!=64;