mysql> select * from typecho_comments order by coid desc limit 1;
+-------+------+------------+--------------------------------------------------------------------+----------+---------+--------------------+--------------------------------------------------------------------+-----------------+--------------------------------------------------------------------------+-------------------------------------------------------+---------+----------+--------+
| coid | cid | created | author | authorId | ownerId | mail | url | ip | agent | text | type | status | parent |
+-------+------+------------+--------------------------------------------------------------------+----------+---------+--------------------+--------------------------------------------------------------------+-----------------+--------------------------------------------------------------------------+-------------------------------------------------------+---------+----------+--------+
| 24539 | 470 | 1448358462 | http://auto.insurance.farm.autoinsurance17.com/usaa-car-quote.html | 0 | 3 | [email protected] | http://auto.insurance.farm.autoinsurance17.com/usaa-car-quote.html | 188.143.234.155 | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0 | Wow, that's a really clever way of thinking about it! | comment | approved | 16247 |
+-------+------+------------+--------------------------------------------------------------------+----------+---------+--------------------+--------------------------------------------------------------------+-----------------+--------------------------------------------------------------------------+-------------------------------------------------------+---------+----------+--------+
1 row in set (0.00 sec)
mysql> delete from typecho_comments where ip = "188.143.234.155";
Query OK, 2405 rows affected (0.07 sec)
mysql> select * from typecho_comments order by coid desc limit 1;
+-------+------+------------+--------------+----------+---------+------------------------+-----------------------+--------------+--------------------------------------------------------------------------------------------------------------+-------------------------+---------+----------+--------+
| coid | cid | created | author | authorId | ownerId | mail | url | ip | agent | text | type | status | parent |
+-------+------+------------+--------------+----------+---------+------------------------+-----------------------+--------------+--------------------------------------------------------------------------------------------------------------+-------------------------+---------+----------+--------+
| 18126 | 531 | 1442480509 | 雪鹰领主 | 0 | 3 | [email protected] | http://kanshenzuo.com | 182.84.18.18 | Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.93 Safari/537.36 | [围观]。。。。。 | comment | approved | 0 |
+-------+------+------------+--------------+----------+---------+------------------------+-----------------------+--------------+--------------------------------------------------------------------------------------------------------------+-------------------------+---------+----------+--------+
1 row in set (0.00 sec)
