How should I write a SQL delete statement?

To write a SQL delete statement, you need to use the DELETE FROM statement followed by the name of the table you want to delete data from, and then use the WHERE clause to specify the conditions of the data you want to delete.

Grammar as follows:

DELETE FROM 表名
WHERE 条件;

For example, if you want to remove a customer named “John” from a table named “customers”, you can do so like this:

DELETE FROM customers
WHERE name = 'John';

Please note that this will delete all rows that meet the criteria. If you only want to delete one row, you can use the LIMIT clause to specify the number of rows to delete, as shown below:

DELETE FROM customers
WHERE name = 'John'
LIMIT 1;

This will only delete the first row that meets the condition.