我可以用工具把整个数据库导出为一个sql语句文件,如下列所示,请问我们ft可以执行下面的这些sql语句吗,因为数据库中的表实在是太多,我想批量转到ft中去
BEGIN TRANSACTION;
CREATE TABLE `Zgdm` (`zgdm` INTEGER PRIMARY KEY NULL DEFAULT NULL,`zgmc` VARCHAR(255) NULL DEFAULT NULL);
INSERT INTO Zgdm VALUES(201,'中共中央办公厅 ');
INSERT INTO Zgdm VALUES(301,'外交部 ');
INSERT INTO Zgdm VALUES(308,'国家民族事务委员会 ');
INSERT INTO Zgdm VALUES(312,'公安部 ');
INSERT INTO Zgdm VALUES(313,'其他主管部门1 ');
INSERT INTO Zgdm VALUES(944,'广东省教育厅 ');
CREATE TABLE batchlines (
"Id" STRING,
"year" INTEGER,
"score" REAL,
"kldm" STRING
);
INSERT INTO batchlines VALUES(3,2013,561.0,0);
INSERT INTO batchlines VALUES(3,2012,564.0,'B');
INSERT INTO batchlines VALUES(5,2012,509.0,'B');
INSERT INTO batchlines VALUES(7,2012,340.0,'B');
INSERT INTO batchlines VALUES(3,2012,572.0,0);
INSERT INTO batchlines VALUES(5,2012,529.0,0);
INSERT INTO batchlines VALUES(7,2012,425.0,0);
INSERT INTO batchlines VALUES(9,2012,200.0,0);
INSERT INTO batchlines VALUES(5,2013,511.0,0);
CREATE TABLE `city` (`Pro_Id` INTEGER NULL DEFAULT NULL,`name` VARCHAR(255) NULL DEFAULT NULL,`xzb` VARCHAR(255) NULL DEFAULT NULL,`yzb` VARCHAR(255) NULL DEFAULT NULL,`filename` VARCHAR(255) NULL DEFAULT NULL,`id` INTEGER NULL );
INSERT INTO city VALUES(2,'安庆',180,335,'anhui.gif',2);
INSERT INTO city VALUES(2,'蚌埠',170,140,'anhui.gif',3);
INSERT INTO city VALUES(2,'亳州',60,80,'anhui.gif',4);
INSERT INTO city VALUES(2,'巢湖',235,250,'anhui.gif',5);
INSERT INTO city VALUES(2,'池州',200,355,'anhui.gif',6);
INSERT INTO city VALUES(2,'滁州',250,155,'anhui.gif',7);
INSERT INTO city VALUES(2,'阜阳',80,155,'anhui.gif',9);
[此贴子已经被作者于2015/10/30 11:22:32编辑过]