CURDATE() : Today's Date in MySQL

CURDATE()

SELECT CURDATE(); 

NOW() & CURDATE()

Yesterday & Tomorrow date by usign CURDATE()

SELECT CURDATE()- interval 1 day  as Yesterday, 
CURDATE() as Today, 
CURDATE()+ interval 1 day as Tomorrow

Last Month , Today and Next Month

SELECT CURDATE()- interval 1 month  as LastMonth, 
CURDATE() as Today, 
CURDATE()+ interval 1 Month as NextMonth

First Day of Previous Month

SELECT DATE_FORMAT(CURDATE() - INTERVAL 1 MONTH,'%Y-%m-01')

Last Day of Previous Month

SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH)

Present Month Records

SELECT * FROM `dt_table` WHERE  
date BETWEEN DATE_FORMAT(CURDATE() ,'%Y-%m-01') AND CURDATE()

Adding current date and time by default to a record.

Read more on how to store default date and time in MySQL table here.

Examples of CURDATE() to get different range of records.