mysql語句

mysql語句

顯示aa表裡的所有内容：

> select * from aa;

顯示aa表裡bb=00的資料：

> select * from aa where bb=00;

顯示aa表裡bb以COM結尾的資料：

> select * from aa where bb like '%COM';

顯示aa表裡以COM結尾的資料的前5行：

> select * from aa where bb like '%COM' limit 5;

統計個數（或叫行數）：

> select count(*) from aa;

從3個表裡抓取需要的資訊（伺服器名、ip、監控項、報錯）：

> select icinga_hosts.display_name,icinga_hosts.address,icinga_services.display_name,icinga_servicestatus.output from icinga.icinga_hosts,icinga.icinga_services,icinga.icinga_servicestatus where icinga_hosts.host_object_id=icinga_services.host_object_id and icinga_services.service_object_id=icinga_servicestatus.service_object_id and icinga_servicestatus.output='CRITICAL - snmpwalk returns no product name (cpqsinfo-mib), wrong device' and icinga_servicestatus.status_update_time like '2017-08-01%';

本文轉自linux部落格51CTO部落格，原文連結http://blog.51cto.com/yangzhiming/1952694如需轉載請自行聯系原作者

yangzhimingg