问对于这两个表中常见的字段，哪个db管理软件可以从一个sqlite3表复制到另一个？

EN

sqlite> CREATE TABLE "a" (
   ...>     "name" TEXT,
   ...>     "address" TEXT
   ...> )
   ...> ;
sqlite> INSERT INTO "a" ("name","address") VALUES ("john","paris");
sqlite> INSERT INTO "a" ("name","address") VALUES ("peter","london");
sqlite> CREATE TABLE "b" (
   ...>         "name" TEXT,
   ...>         "address" TEXT,
   ...>         "contact" TEXT
   ...>     );
sqlite> INSERT INTO "b" ("name","address") SELECT "name","address" FROM "a";
sqlite> SELECT * FROM "b";
john|paris|
peter|london|