记录一个mysql遇见的的坑

#1
SELECT * from bsc_erc1155_owner WHERE token_contract='0x568bd06e22e7030798f06d4f44a55c1e708ce1b2';

#2
SELECT * FROM nft_asset_bsc WHERE token_contract='0x568bd06e22e7030798f06d4f44a55c1e708ce1b2';

#3
select token_contract, token_id , sum(own_count) as own_count from bsc_erc1155_owner where token_contract='0x568bd06e22e7030798f06d4f44a55c1e708ce1b2' and token_id in ( '0x0000000000000000000000000000000000000000000000000000000000000002' , '0x0000000000000000000000000000000000000000000000000000000000000001' ) and own_count>0;

#4
select token_contract, token_id , count(own_count) as own_count from bsc_erc1155_owner where token_contract='0x568bd06e22e7030798f06d4f44a55c1e708ce1b2' and token_id in ( '0x0000000000000000000000000000000000000000000000000000000000000002' , '0x0000000000000000000000000000000000000000000000000000000000000001' ) and own_count>0;

#5
select token_contract, token_id , max(own_count) as own_count from bsc_erc1155_owner where token_contract='0x568bd06e22e7030798f06d4f44a55c1e708ce1b2' and token_id in ( '0x0000000000000000000000000000000000000000000000000000000000000002' , '0x0000000000000000000000000000000000000000000000000000000000000001' ) and own_count>0;

总结：
mysql查询的时候
如果查询中带了聚合函数，返回的是一条空数据
如果不带，则返回的空