mysql 储存年月的类型_mysql数据类型仅存储月份和年份

最新推荐文章于 2024-07-21 03:07:33 发布

不上前十不改名

最新推荐文章于 2024-07-21 03:07:33 发布

阅读量2.1k

点赞数

文章标签： mysql 储存年月的类型

本文链接：https://blog.csdn.net/weixin_32501329/article/details/113226051

版权

在构建PHP应用程序并需要在MySQL数据库中存储学生的意向毕业年月时，文章探讨了存储方式的选择。考虑到不需要记录具体日期，作者建议可以将日期始终记录为1号，并使用DATE数据类型，利用MONTH()和YEAR()数据库函数来处理查询。由于数据主要用于报告展示而非复杂操作，此方案能够满足需求。

摘要由CSDN通过智能技术生成

I'm writing a php application that will store STUDENT data in a MySQL relational database. I'm trying to find the best way/datatype to store a month and year together without the day. I don't know whether I should just store it as a DATE and use php someway to just store the day as the 1st or use a different datatype that I'm not currently familiar with. Ideally, I do not want to store a day, because the day will not always be the same and would require changing php source code if the day changed in the future.

Just for more background info, I'm storing a STUDENT's INTENT_TO_GRAD. The client seems to only want this information as a reference or a visual for a report as opposed to using it for data manipulation. In other words, the only functional requirement for th