mysql刪除查詢

树树先生發表於2024-07-09
MySql

SELECT * FROM tx_report.tbl_hostinfo WHERE hostmac = 'FE-FC-FE-8X-XX-XX'; 查詢

DELETE FROM tx_report.tbl_hostinfo WHERE hostmac = 'FE-FC-FE-8X-XX-XX' ; 刪除

DELETE FROM tx_alert.tbl_audit_print WHERE occurtime < '2023-10-10 09:59:25' LIMIT 10000; 刪除指定時間，不超過10000行

相關文章