How to implement Soft Delete?
Code Playground
JavaScript (V8)
Loading...
Console Output
// Output will appear here...
// For React: ReactDOM.createRoot(rootElement).render(<App />);
// For React: ReactDOM.createRoot(rootElement).render(<App />);
Recommended Answer
sql
-- Don't DELETE. Update 'is_deleted' flag.
UPDATE Users SET is_deleted = 1 WHERE UserID = 10;
-- Querying
SELECT * FROM Users WHERE is_deleted = 0;