//menghapus semua data dari sebelum 1 hari
SELECT * FROM Orders WHERE OrderDate < DATE_SUB("1996-10-03", INTERVAL 10 DAY);
SELECT * FROM Orders WHERE OrderDate < DATE_SUB(NOW(), INTERVAL 10 DAY);
//menghapus semua data dari sebelum 1 bulan
SELECT * FROM Orders WHERE OrderDate < DATE_SUB("1996-10-03", INTERVAL 1 MONTH);
Friday, September 17, 2021
Menghapus catatan Sebelum Tanggal Tertentu
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment