Java优学网MySQL删除数据入门解析：从基础DELETE到安全逻辑删除实战

DELETE FROM table_name;

DELETE FROM table_name;

String sql = "DELETE FROM users WHERE status = ? AND last_login < ?"; try (Connection conn = dataSource.getConnection();

 PreparedStatement pstmt = conn.prepareStatement(sql)) {

pstmt.setString(1, "inactive");
pstmt.setDate(2, Date.valueOf("2023-01-01"));

int affectedRows = pstmt.executeUpdate();
System.out.println("删除了 " + affectedRows + " 条记录");

} catch (SQLException e) {

// 实际项目中这里应该有更完善的异常处理
e.printStackTrace();

}

ALTER TABLE users ADD COLUMN is_deleted TINYINT DEFAULT 0; ALTER TABLE users ADD COLUMN deleted_at DATETIME;

-- 逻辑删除而非物理删除 UPDATE users SET is_deleted = 1, deleted_at = NOW() WHERE user_id = 123;