mysql copy data from table to another

insert  into telnet_ip_range(ip_range, country, scan_status, scan_update_at) select ip_range, country, 0, NULL  from ipv4.ipv4_pool;

原文地址:https://www.cnblogs.com/hotbaby/p/5122438.html