mysql操作问题记录

select…select

SELECT * from (SELECT distinct instances.uuid,size as size_rootvolume,cinder.volumes.id as rootvolume_id,cinder.volumes.display_name as rootvolume_name FROM ......) as first_filter GROUP BY uuid;

查询包含关键字key

select * from cinder.volume_metadata where volume_id='aaaaaaaaaaaaaaaaaaaa' and `key`='read_bytes_sec';