Sql语句

1 Sqlite将其他数据库的表迁移到当前数据数据

update unit_map_field set field='';

drop table unit_map_field;

ATTACH DATABASE 'D:\temp\config-s.biz' AS otherDB;
CREATE TABLE unit_map_field AS SELECT * FROM otherDB.unit_map_field;
DETACH DATABASE otherDB;