我应该在MySQL中使用datetime或timestamp数据类型吗? [英] Should I use the datetime or timestamp data type in MySQL?
问题描述
建议您使用 datetime 或时间戳字段,为什么(使用MySQL)?
Would you recommend using a datetime or a timestamp field, and why (using MySQL)?
我正在服务器端使用PHP.
I'm working with PHP on the server side.
推荐答案
MySQL中的时间戳通常用于跟踪记录的更改,并且通常在每次更改记录时进行更新.如果要存储特定值,则应使用datetime字段.
Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field.
如果您想在使用UNIX时间戳还是本机MySQL日期时间字段之间做出选择,请使用本机格式.您可以通过这种方式在MySQL中进行计算
("SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)")
,如果要使用PHP对记录进行查询,则很容易将值的格式更改为UNIX时间戳("SELECT UNIX_TIMESTAMP(my_datetime)")
.
If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go with the native format. You can do calculations within MySQL that way
("SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)")
and it is simple to change the format of the value to a UNIX timestamp ("SELECT UNIX_TIMESTAMP(my_datetime)")
when you query the record if you want to operate on it with PHP.
这篇关于我应该在MySQL中使用datetime或timestamp数据类型吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!