select * into zhkc from lskc 复制表so easy。
备份单个表很实用
sqldel = "delete from zhkc where FA not in(select min(FA) from zhkc group by A0)";
可以删除重复记录,稍加变换可以作用无穷,比如根据时间戳就行增量下载后,删除原来的库存数据。
select * into zhkc from lskc 复制表so easy。
备份单个表很实用
sqldel = "delete from zhkc where FA not in(select min(FA) from zhkc group by A0)";
可以删除重复记录,稍加变换可以作用无穷,比如根据时间戳就行增量下载后,删除原来的库存数据。
转载于:https://www.cnblogs.com/EverShine/archive/2010/12/14/1905940.html