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

8 votes206 views1 answer
Racle create auto increment column
SQL
2 votes167 views1 answer
Mysql add boolean column
SQL
0 vote300 views1 answer
Sql change a colum to unique
SQL
4 votes181 views6 answers
Second max salary in sql
SQL
0 vote195 views1 answer
PostgreSQL types and C# types
SQL
3 votes182 views2 answers
How to start mysql in terminal
SQL
0 vote177 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote189 views1 answer
Column ' ' in field list is ambiguous
SQL
11 votes192 views2 answers
Mysql set safe mode off
SQL
8 votes205 views2 answers
Replace string value in sql
SQL