1.登录型校验 limit 1,例如:

SELECT
`password`
FROM
worker
WHERE
phone = 18611406603
LIMIT 1

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

　　结果无值,不需验证;有值,校验

 

2.存在型验证 select 1, 例如:

SELECT
1
FROM
worker
WHERE
phone = 18611406603    存在为1,否则为空

3.数量型查询 SELECT COUNT(1) 例如:

SELECT
COUNT(1)
FROM
worker
WHERE
phone = 18611406603

4.字段型查询 

SELECT
`password`
FROM
worker
WHERE
phone = 18611406603

5.字段型 带页码

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄