針對MySQL的between語句和in語句的區(qū)別
select * from atable where column beteen min and max
——between是指屬性值在min和max之間,包括min和max徽级,
selset * from atable where column in (n1,n2,n3)
——in則是將括號(hào)內(nèi)的數(shù)當(dāng)做數(shù)組處理搂根,只有當(dāng)記錄的屬性值等于括號(hào)內(nèi)的數(shù)值之一時(shí)陕贮,該記錄才會(huì)被選中