How to delete data in MySQL?

12 months ago

Benjamin Taylor

1 minute

To delete data in MySQL, you can use the DELETE statement. The basic syntax of the DELETE statement is as follows:

DELETE FROM table_name WHERE condition;

In this case, table_name is the name of the table from which data is to be deleted, and condition is an optional criteria used to specify the data to be deleted.

For example, if you want to delete the data with id of 1 in the table, you can use the following statement:

DELETE FROM table_name WHERE id = 1;

To delete all data in a table, you can use the following statement:

DELETE FROM table_name;

It is important to note that the DELETE statement will directly remove data, so it is necessary to carefully consider before executing to avoid accidentally deleting data.