Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql-查询一个表用户对新增用户进行统计不能用not in 需要用exists

mysql-查询一个表用户对新增用户进行统计不能用not in 需要用exists

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-06 09:33:02
Original
1171 people have browsed it

mysql

下面是用not in 实现的 ，需要修改为 exists实现
SELECT COUNT(*) from order_info_ref as oif where oif.order_time>='2016-03-02 00:01:00' and oif.order_time(SELECT oi.ca_user_id from order_info_ref as oi where oi.order_time>='2016-03-01 00:01:00' and oi.order_time

Related labels：
mysql
Previous article：如何用javaben jsp servlet编写用户登录后显示个人资料，与mysql相连 Next article：linux环境 php如何配置链接mysql
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The problem that mysql service cannot be restarted after mysql upgrade
From 1970-01-01 08:00:00
0
0
0
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
php - In wamp, how to use mysql installed by myself instead of wamp integrated mysql?
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template