1、查詢id=1,3記錄的所有數(shù)據(jù) select * from mytable where id in(1,3) 2、刪除id重復(fù)的數(shù)據(jù),表中數(shù)據(jù)只剩下id=1,2,3的所有數(shù)據(jù) select * into # from mytable truncate table mytable
insert table select distinct * from # select * from table drop table #