删除分类ID下面所有数据

delete from m_data where m_type in(25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)

 

UPDATE Content SET 播放器 ='xfplay' where id>5124
5124
播放器

UPDATE Content SET 数据地址 = 来源 where id in(5112,5113,5114,5115,5116,5117,5118,5119,5120,5121,5122,5123,5124)
UPDATE Content SET 数据地址 = 来源 where id in(2117,2118,2119,2120,2121,2122,2123,2124)

转载于:https://www.cnblogs.com/94YY/archive/2012/08/21/2650042.html