1、mysql

INSERT INTO xxxx.t_region(f_id,f_parentid,f_region_name,f_region_type)
SELECT region_id,parent_id,region_name,region_type
FROM ecshop273.ecs_region

2、sqlite

INSERT INTO t_region(f_id,f_parentid,f_region_name,f_region_type)
SELECT region_id,parent_id,region_name,region_type
FROM ecs_region

http://sqlite.org/lang_insert.html

似乎sqlite的好多sql语句和mysql极为相似