How to delete a row of data in a table in SQL?

To remove a row of data from a table, you can use the DELETE statement. The basic syntax of the DELETE statement is as follows:

DELETE FROM 表名 WHERE 条件;

In this case, the table name refers to the name of the table from which data needs to be deleted, while the condition specifies which rows to delete.

For example, to delete the employee record with the employee number 1001 from the table named “employees”, you can use the following statement:

DELETE FROM employees WHERE employee_id = 1001;

This will delete the rows in the table that meet the condition.