mysql 查询
余温
2018年08月01日 09时30分
php
//打印执行的最后一条sql语句 echo db()->getLastSql();exit(); //模糊查询 $where['title|desc|account']=['like',["%$seek%"]]; $list = db('article')->where($where)->order('time desc')->paginate(8); //正则查询 SELECT * FROM tp_present_user WHERE account REGEXP '^L' //查询a表中的 account 在b表中不存在的 SELECT * FROM a表 WHERE account NOT IN (SELECT account FROM B表 ) AND is_pay=1 UPDATE bt_fck_member_copy1 a , bt_fck_userinfo_copy1 b SET a.user_name = b.user_name WHERE a.uid=b.uid SELECT account FROM tp_users WHERE vip_time BETWEEN UNIX_TIMESTAMP('2018-07-26 00:00:00') AND UNIX_TIMESTAMP('2018-08-01 00:00:00')
上一篇:
php截取圆角
下一篇:
mysql 查询重复数据
请登陆后评论
{{vo.time}} 回复