mysql 命令

select * from mm1 where ma not regexp '[ABCDEF]'  查询ma字段中不包含ABCDEF中任意字符的所有记录
select * from mm1 where ma  regexp '[ABCDEF]'  查询ma字段中包含ABCDEF中任意字符的所有记录
select * from liepinwangzhi where  wz like '%1933679845%'   查询wz字段内容中是否有包含字符串1933679845（wz 字符串255）

select count(*) from baocun1 where bzz is null    统计bzz字段内容为null的记录条数

select count(*) from  xinxi m,(select zhiwei,gongsi,gongzi,xueli,jingyan from xinxi group by zhiwei,gongsi,gongzi,xueli,jingyan having count(1))as m1 where m.zhiwei=m1.zhiwei and m.gongsi=m1.gongsi and m.gongzi=m1.gongzi and m.xueli=m1.xueli and m.jingyan=m1.jingyan  统计xinxi表中zhiwei,gongsi,gongzi,xueli,jingyan不都相同的记录条数

SELECT count(*) FROM xinxi
WHERE
(
zhiwei IN (SELECT zhiwei FROM xinxi GROUP BY zhiwei,gongsi,gongzi HAVING COUNT(*)>1)
AND gongsi IN (SELECT gongsi FROM xinxi GROUP BY zhiwei,gongsi,gongzi HAVING COUNT(*)>1)
AND gongzi IN (SELECT gongzi FROM xinxi GROUP BY zhiwei,gongsi,gongzi HAVING COUNT(*)>1)
)

select * from xinxi53 where rq=(select min(rq) from xinxi53)显示rq最小的记录

update xinxi1,(select distinct gongsi,gslx from xinxi53) as bb set xinxi1.gslx=bb.gslx where xinxi1.gongsi=bb.gongsi  用临时表更新
update xinxi1,(select distinct gongsi,gsrs from xinxi53) as bb set xinxi1.gsrs=bb.gsrs where xinxi1.gongsi=bb.gongsi