- 号码 套餐资费 卡费 话费 操作
- 号码 套餐资费 卡费 话费 操作
MySQL Query : SELECT COUNT(*) AS num FROM `www_haomahao_com`.`cms_haoma` WHERE `status` = '99' AND `yunyingshang` = 1 AND AND kafei >= 50000 AND right(haoma,4) >= 1970 and right(haoma,4) < 1980 AND (
floor(right(haoma,2)) mod 11 = 0 and floor(mid(haoma,length(haoma)-3,2)) mod 11 =0 and floor(mid(haoma,length(haoma)-5,2)) mod 11 =0 and floor(right(haoma,2))<>floor(mid(haoma,length(haoma)-3,2))<>floor(mid(haoma,length(haoma)-5,2))
) LIMIT 1
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kafei >= 50000 AND right(haoma,4) >= 1970 and right(haoma,4) < 1980 AND (\x0' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kafei >= 50000 AND right(haoma,4) >= 1970 and right(haoma,4) < 1980 AND (\x0' at line 1
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kafei >= 50000 AND right(haoma,4) >= 1970 and right(haoma,4) < 1980 AND (\x0' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND kafei >= 50000 AND right(haoma,4) >= 1970 and right(haoma,4) < 1980 AND (\x0' at line 1