摘要:
SELECT *,type,status,server_id FROM `dp_email_server` server LEFT JOIN `dp_email_stop` stop ON (server.smtp_id = stop.server_id) WHERE status = '0' AN 阅读全文
摘要:
平时开发中,常用一些模糊查询,例如查询表格user中uname包含“塔”的数据,可以使用如下三种方式: select * from user where uname like '%塔%';select * from user where INSTR(uname,'塔');select * from 阅读全文
摘要:
基本常用查询 --select select * from student; --all 查询所有 select all sex from student; --distinct 过滤重复 select distinct sex from student; --count 统计 select cou 阅读全文