表 SQL_TXT 的 SQL_CODE 字段的每的行都是一个SQL语句,如何把这每一行的SQL语句依次都执行了,谢谢!
表名: SQL_TXT (ID VARCHAR(10) ,SQL_CODE VARCHAR(6000) ;
--插入测试数据
INSERT INTO SQL_TXT ('1','INSERT INTO TAB_0 SELECT * FROM TAB_1 ');
INSERT INTO SQL_TXT ('1','INSERT INTO TAB_0 SELECT * FROM TAB_2 ');
INSERT INTO SQL_TXT ('1','INSERT INTO TAB_0 SELECT * FROM TAB_3 ');
----预期:执行如下SQL,把数据插入到TAB_0 表
INSERT INTO TAB_0 SELECT * FROM TAB_1;
INSERT INTO TAB_0 SELECT * FROM TAB_2;
INSERT INTO TAB_0 SELECT * FROM TAB_3;
表名: SQL_TXT (ID VARCHAR(10) ,SQL_CODE VARCHAR(6000) ;
--插入测试数据
INSERT INTO SQL_TXT ('1','INSERT INTO TAB_0 SELECT * FROM TAB_1 ');
INSERT INTO SQL_TXT ('1','INSERT INTO TAB_0 SELECT * FROM TAB_2 ');
INSERT INTO SQL_TXT ('1','INSERT INTO TAB_0 SELECT * FROM TAB_3 ');
----预期:执行如下SQL,把数据插入到TAB_0 表
INSERT INTO TAB_0 SELECT * FROM TAB_1;
INSERT INTO TAB_0 SELECT * FROM TAB_2;
INSERT INTO TAB_0 SELECT * FROM TAB_3;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货