你将"insert into B([1],[2],[3],[4]) select [1],[2],[3],[4] from A where [4]='A4'"分为两步执行试试,就是excutestr = "insert into B([1],[2],[3],[4])"执行excutestr = "select [1],[2],[3],[4] from A where [4]='A4'“执行
用高级语言写数据库操作时要写‘excute’函数来拼接数据库语句。