DELETE Statement MYSQL
Let’s see how we can delete data rows from a table
The DELETE statement is used to delete existing records in a table.
DELETE FROM table_name WHERE condition;
DELETE FROM Persons WHERE City='Bangalore'
As you see the condition matched for 1 row and hence 1 row is deleted with persons records with city as ‘Bangalore
Tester Usage Tips:
- Delete table records with condition and validate connected tables data rows for integrity