常见

select * from gb_price where mine_code is null AND mine not in ('RE','Sn','K') LIMIT 10

select * from gb_price where mine_code is null AND day = 0

DELETE FROM gb_price where mine_code is null AND day = 0

UPDATE gb_price set mine_code = '32017' where mine='rezzz'