Mysql - Delete a row, How to delete a particular row

Delete a row

In mysql if you want to delet a particular row or column you can follow the below steps. Before deleting the row from the table make sure that what you are doing. Once if you delete the row then it cant be recovered.

Syntax:

 delete from table_name where column_name='value';

Example:

 mysql> delete from mytable where id='458';

The above example will delete a particular row from the table where table name is mytable and the id is 458.

The topic on Mysql - Delete a row is posted by - Maha

Hope you have enjoyed, Mysql - Delete a rowThanks for your time