有select max() from table 的问题，高手进来看看

[zazah]

我想在做日结时做数据转移，比方说从TBL1到TBL2中，TBL1中的自动产生的ID为100，那我想从ID为50的记录转移到TBL2中，一直ID写到100，请问怎么办呀？？

[ctseu]

insert into tbl2 select * from tbl1 where id between 50 and 100
delete from tbl1 where id between 50 and 100
日结时做数据转移?
你是不是要做日报之类的报表？
如果做日报的话，你不用转移阿，直接从tbl1获取你需要的统计信息，然后将每日统计结果保存到另一个表中就可以了，这样你做月报也很方便啊

[饮水需思源]

insert into tbl2 select * from tbl1 where id between 50 and 100
delete from tbl1 where id between 50 and 100

'不过不是很明白楼主为什么要转移数据

[clear_zero]

insert into tbl2 select * from tbl1 where id between 50 and 100
delete from tbl1 where id between 50 and 100