定义 zt char(1)select * from cqb where mod(ascii(zt),2)=1; --b0为1 select * from cqb where mod(CEIL(ascii(zt)/2),2)=1; --b1为1 select * from cqb where mod(CEIL(ascii(zt)/4),2)=1; --b2为1 select * from cqb where mod(CEIL(ascii(zt)/8),2)=1; --b3为1 select * from cqb where mod(CEIL(ascii(zt)/16),2)=1; --b4为1
select * from cqb where mod(CEIL(ascii(zt)/2),2)=1; --b1为1
select * from cqb where mod(CEIL(ascii(zt)/4),2)=1; --b2为1
select * from cqb where mod(CEIL(ascii(zt)/8),2)=1; --b3为1
select * from cqb where mod(CEIL(ascii(zt)/16),2)=1; --b4为1
你这么牛。。自己搞定好了。。
移位怎么做???