insert union all 不能成功执行
mysql 执行下面的失败
nsert into subfull(time,data,des,value,newTime,newData)
select * from subscription
union all
select * from subscription1
union all
select * from subscription2
union all
select * from subscription3
union all
select * from subscription4
union all
select * from subscription5
union all
select * from subscription6
union all
select * from subscription7
如果单独执行nsert into subfull(time,data,des,value,newTime,newData)
select * from subscription是成功的 并且很快。7次 不过7分钟
但union all insert 花了半个小时不能得到结果。 为什么??