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 vote104 views1 answer
Where date in datetime mysql
SQL
3 votes107 views3 answers
Mysql declare variable
SQL
3 votes106 views2 answers
Mysql select database
SQL
0 vote105 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
7 votes110 views5 answers
Max 3 salary in sql
SQL
0 vote104 views1 answer
Mysql select row with min date
SQL
0 vote104 views1 answer
Sql how to get courses that i have made prerequisites
SQL
2 votes146 views1 answer
Tsql copy table
SQL
1 vote99 views3 answers
Union SQL
SQL
16 votes102 views6 answers
Install sqlite3 python
SQL