Generate INSERT statement from SELECT query
I wasn't clear where you want the transformed id_estado inserted, so I chose "state" as a destionation.   You can modify accordingly:

insert into courrier_city (country, state, created, modified) select "VE", if(is_estado&lt;10, concat("VE0.",is_estado),concat("VE.",is_estado)), now(), now() from zoom_city


You will probably want to modify the example further to account for specifying all the destination columns with either a literal value such we did for country, a transform like we did for is_estado, or just the basic column name in the select portion to copy values.

You should specify some value for every destination column without a schema default defined.