Mysql 游戏剩余时间数据类型

Question

我正在开发一款跟踪高中体育赛事比分的应用。

它将允许用户提交正在进行的游戏分数。现在我有一个名为分数的数据库表。

但是当涉及到以分钟和秒表示游戏中剩余的时间量时，我感到困惑。

Answer 1

您可以使用 TIME type :

MySQL retrieves and displays TIME values in 'HH:MM:SS' format (or 'HHH:MM:SS' format for large hours values). TIME values may range from '-838:59:59' to '838:59:59'. The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), but also elapsed time or a time interval between two events (which may be much greater than 24 hours, or even negative).