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

9 votes355 views3 answers
Postgres make sql dump
SQL
0 vote379 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote324 views1 answer
How to display value of variable in mysql
SQL
0 vote334 views1 answer
Postgres clear table
SQL
0 vote333 views1 answer
Mysql shell ERROR: Not connected.
SQL
4 votes353 views1 answer
List tables sqlite
SQL
1 vote308 views1 answer
Input in mysql
SQL
0 vote317 views1 answer
Retornar apenas o ano mysql date
SQL
8 votes386 views2 answers
Default sql server port
SQL
0 vote331 views1 answer
Mysql where in keep order
SQL