SqlServer, Mysql and Sqlite delete the way data was written one month ago

This article mainly introduces "SqlServer, Mysql and Sqlite delete a month ago data writing method". In daily operation, I believe many people have doubts about how SqlServer, Mysql and Sqlite delete the data one month ago. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "SqlServer, Mysql and Sqlite delete the data before a month". Next, please follow the editor to study!

Mysql

Delete from tb_log where createTime < date_add (curdate (), INTERVAL-1 month)

SqlServer:

Delete from tongbu_log where create_time ='30 years; at this point, the study on "how to write data before SqlServer, Mysql and Sqlite deleted a month ago" is over. I hope I can solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!