mysql> use wordpress_db; mysql> select agentID from wp_Counterize where timestamp like "2011-11-12%" limit 20; +---------+ | agentID | +---------+ | 1925 | | 8 | | 1627 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | | 5225 | | 5225 | | 6233 | | 6233 | | 6233 | | 6233 | | 6233 | +---------+ mysql> select * from wp_Counterize_UserAgents where agentID = 6233; +---------+------------------------+-------+-------------+-------------+----------------+------------+---------+---------+-----------+-------+ | agentID | name | count | browserName | browserCode | browserVersion | browserURL | osName | osCode | osVersion | osURL | +---------+------------------------+-------+-------------+-------------+----------------+------------+---------+---------+-----------+-------+ | 6233 | W3 Total Cache/0.9.2.4 | 940 | Unknown | unknown | | | Unknown | unknown | | | +---------+------------------------+-------+-------------+-------------+----------------+------------+---------+---------+-----------+-------+ 1 row in set (0.00 sec) mysql> select count(1) from wp_Counterize where agentID = "6233"; +----------+ | count(1) | +----------+ | 940 | +----------+ 1 row in set (0.04 sec) mysql> mysql> select count(1) from wp_Counterize where agentID = "6233" and timestamp like "2011-11-12%"; +----------+ | count(1) | +----------+ | 890 | +----------+ 1 row in set (0.00 sec) mysql> mysql> select count(1) from wp_Counterize where agentID = "6233"; +----------+ | count(1) | +----------+ | 940 | +----------+ 1 row in set (0.04 sec) mysql> mysql> delete from wp_Counterize where agentID = "6233"; Query OK, 940 rows affected (0.23 sec) mysql> FLUSHPRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
以上
コメント