[MySQL]日付けによるcount

LINEで送る
Pocket

select count(id) from user where login_date >= '2018-06-17' and login_date < '2018-06-18';
+-----------+
| count(id) |
+-----------+
|     xxxxxxx |
+-----------+
1 row in set (2.10 sec)

 

> select count(id) from views where dt = '2019-xx-xx';
+-----------+
| count(id) |
+-----------+
|     xxxxxx |
+-----------+

Was this helpful?

0 / 0

コメントを残す 0

Your email address will not be published. Required fields are marked *