+=
CONCAT(substring(vmcode,13,4),'-',substring(vmcode,17,2)
INSERT into allhost select vmcode,CONCAT(substring(vmcode,13,4),'-',substring(vmcode,17,2),'-',substring(vmcode,20,2)),end_time from host_destroy_copy;
+=
CONCAT(substring(vmcode,13,4),'-',substring(vmcode,17,2)
INSERT into allhost select vmcode,CONCAT(substring(vmcode,13,4),'-',substring(vmcode,17,2),'-',substring(vmcode,20,2)),end_time from host_destroy_copy;