Mysql sysdate - 1 day

 -- Sysdate in MySQL
 SELECT SYSDATE();								-- 2021-07-13 06:12
 SELECT DATE_ADD(SYSDATE(), INTERVAL 1 DAY);	-- 2021-07-14 06:12
 SELECT DATE_ADD(SYSDATE(), INTERVAL -1 DAY);	-- 2021-07-12 06:12
 SELECT DATE(SYSDATE());						-- 2021-07-13 00:00
 
 -- ⇓ Test it ⇓ (Fiddle source link)

Source: sqlfiddle.com

Similar codes

0 vote302 views1 answer
How to create notes in mysql
SQL
3 votes273 views1 answer
Mysql replace string in table
SQL
0 vote289 views1 answer
Sqlite version check
SQL
0 vote252 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote287 views1 answer
Sql server list table sizes
SQL
0 vote282 views1 answer
Mysql c commands
SQL
0 vote264 views1 answer
Many rows to 1 string mysql
SQL
0 vote281 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote284 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
58 votes537 views6 answers
Create new user in postgres
SQL