记录

先把down_new数据库的主键设置成自增长


INSERT INTO down_new( fid, zid, chapter,
TYPE , TIME, error )
SELECT fid, zid, chapter,
TYPE , TIME, error
FROM down

WHERE down.error =0;


INSERT INTO down_new (fid, zid,chapter,type,time,error) SELECT fid, zid,chapter,type,time,error FROM down where down.error=0


把down数据error=0导入down_new


这个是个人记录。