删除不符合要求的数据
DELETE FROM huiyisheji WHERE id<10 and m_format not in ("","eps","cdr","psd","jpg","png","zip","rar","jpeg")
update 表名 set 字段 where 条件
例:
update 表名 set cm_dir=0 where m_format not in ("","eps","cdr","psd","jpg","png","zip","rar","jpeg")