mysql 插入不了数据_MySQL – 增加列值或插入数据(如果不存在)

您是否绝对想在插入动作时计算计数器值？使用时间戳简单地跟踪用户和操作可能更简单,如下所示：

+--------+----------+---------------------+

| UserID | ActionID | Time |

+--------+----------+---------------------+

| 1 | 1 | 2012-01-19 14:47:03 |

| 1 | 2 | 2012-01-19 14:48:12 |

| 1 | 3 | 2012-01-19 14:48:15 |

| 2 | 1 | 2012-01-19 14:49:33 |

| 2 | 1 | 2012-01-18 14:49:42 |

然后使用查询计算每日计数：

SELECT UserID,

ActionID,

DATE(Time) AS Date,

COUNT(*) AS n

FROM actions

GROUP BY UserID,ActionID,Date

ORDER BY Date,UserID,ActionID;

+--------+----------+------------+---+

| UserID | ActionID | Date | n |

+--------+----------+------------+---+

| 1 | 2 | 2012-01-17 | 2 |

| 1 | 3 | 2012-01-17 | 2 |

| 3 | 2 | 2012-01-17 | 6 |

| 1 | 1 | 2012-01-18 | 1 |

| 1 | 2 | 2012-01-18 | 1 |

| 1 | 3 | 2012-01-18 | 4 |