Mysql Curdate MonthName 函数的结束值

Question

美好的一天，所以我知道您可以轻松创建选择语句和 View ，并执行

 select curdate() from accounts  

然后以表名结尾

 select curdate() as demodate from accounts.

但是我该如何做到这一点。

 select month(curdate()) as monthname(curdate()),
 month(curdate()-1) as monthname(curdate()-1)
 from accounts

Answer 1

您似乎想要的只是本月的号码和姓名以及上个月的号码和姓名

select month(curdate()), monthname(curdate()),
          month(curdate()) - 1, 
            monthname(date_sub(curdate(), interval 1 month));

+------------------+----------------------+----------------------+--------------------------------------------------+
| month(curdate()) | monthname(curdate()) | month(curdate()) - 1 | monthname(date_sub(curdate(), interval 1 month)) |
+------------------+----------------------+----------------------+--------------------------------------------------+
|               12 | December             |                   11 | November                                         |
+------------------+----------------------+----------------------+--------------------------------------------------+
1 row in set (0.00 sec)