苹果cmsV10常用sql语句删除数据
DELETEFROM {pre}vod 删除所有数据DELETEFROM {pre}vod WHERE vod_id=1000 删除指定的第几条数据
DELETEFROM {pre}vod WHERE vod_actor LIKE '%刘德华%' 删除vod_actor字段里有"刘德华"的数据
DELETEFROM {pre}vod WHERE vod_type=1 删除指定的分类ID的数据
DELETEFROM {pre}vod WHERE vod_area LIKE '%台湾%' 删除指定地区的数据
DELETEFROM {pre}vod WHERE vod_lang LIKE '%粤语%'删除指定语言的数据
页:
[1]