SELECT SUM(字段) FROM (SELECT 字段 FROM A1216 UNION SELECT 字段 FROM A1217 UNION... ) AS T1
Yes!每天好多! 一个表怕太忙!
写到同一个表里才好管理哦,弄这么多表效率低不说,也占数据库资源啊 如果表结构相同,那就再建一个表A12,然后批量执行 insert into A12 select * from A1211 insert into A12 select * from A1212 insert into A12 select * from A1213 insert into A12 select * from A1214 insert into A12 select * from A1215 insert into A12 select * from A1216 insert into A12 select * from A1217 最后统一对A12表进行统计,但这只是权宜之计,还是建议楼主以后直接把数据写到一个表里,addoil
(SELECT 字段 FROM A1216
UNION
SELECT 字段 FROM A1217
UNION...
) AS T1
一个表怕太忙!
如果表结构相同,那就再建一个表A12,然后批量执行
insert into A12 select * from A1211
insert into A12 select * from A1212
insert into A12 select * from A1213
insert into A12 select * from A1214
insert into A12 select * from A1215
insert into A12 select * from A1216
insert into A12 select * from A1217
最后统一对A12表进行统计,但这只是权宜之计,还是建议楼主以后直接把数据写到一个表里,addoil