mysql> select date_format(curdate() - interval 1 month,'%y-%m-01') as 'first day of prevoius month';+-----------------------------+| first day of prevoius month |+-----------------------------+| 2017-09-01 |+-----------------------------+1 row in set (0.00 sec)
以上就是如何在mysql中获取上个月的第一天？的详细内容。