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行
<前 >后