DELETE

DELETE permanently removes matching rows unless the application has an explicit soft-delete policy. Check the WHERE clause and expected affected-row count; omitting WHERE deletes every row. For consequential data, confirm authorization and consider a transaction or recoverable archival strategy. The sample scopes deletion to one known record identifier. Further guidance Use migrations to version schema changes, constraints to protect relationships, and prepared statements for every dynamic value. Scope writes with a precise condition, check affected rows, and use transactions when multiple statements must succeed together. Store credentials outside source control. Practice task: Create a fresh example for DELETE. Predict the result before running it, then change one input and explain why the result changes. Test a normal case and one boundary or invalid case where it applies. Compare your output with the example and note one rule you would use in a real project.