指着他活着呢

SELECT a.id, a.`full_name`, a.`category`, bin(a.`category`),
substr(REVERSE(LPAD(bin(a.`category`), 20, '0')), 7, 1) 是否,
REVERSE(LPAD(bin(a.`category`), 20, '0'))
FROM `appliter`.`aws_advisor_info` a
HAVING 是否 = '1';

posted @ 2019-01-18 10:31  Python界-黄药师  阅读(99)  评论(0编辑  收藏  举报