• notice
  • Congratulations on the launch of the Sought Tech site

Time type selection of mysql

Interval type: Try to use the TIMESTAMP type, because its storage space only needs half of the DATETIME type.For data types that only need to be accurate to a certain day, it is recommended to use the DATE type, because its storage space only requires 3 bytes, which is less than TIMESTAMP.It is not recommended to store a unix timestamp value through the INT type class, because it is too unintuitive and will cause unnecessary trouble for maintenance without bringing any benefits.

Tags

Technical otaku

Sought technology together

Related Topic

0 Comments

Leave a Reply

+