How do I delete a row from a table?

[diyasaini]

Hello friends,

I want to know that How do I delete a row from a table in MySQL database ?

[Guest]

It is very simple to delete the row from table.
1. Select the row you want to delete.
2. On the table menu point to delete and then click either rows

[deepika]

DELETE FROM EMP WHERE ID=1 AND NOT EXISTS(SELECT * FROM BAR WHERE ID=1)
In the above example EMP and BAR are tables and I want to remove a record from EMP if it doesn't exists in bar.

[rohit]

The delete statement is used to delete rows in a table
DELETE FROM table name
WHERE Customer Name=’rohit’;

[stevex]

use the query :
DELETE FROM table_name
WHERE column=value;
for e.g.
DELETE FROM customers
WHERE customer='ram';

[Guest]

You can delete it by the delete command.

[Daljeet]

This is very simple way to delete.Firstly select row you want to delete then apply delete command.

[AmitSood]

You can use this syntax

DELETE FROM table_name WHERE column_name=some_value

[sangeetanegi]

Thanks for sharing this information.

[shilparana]

It is so simple, select the row you want to delete then apply delete command.

[sapnathakur]

Yes. its too easy to delete a row just Select the row you want to delete.

[sangeetanegi]

Delete columns and rows, right-click a row or column, and then click the command you want. You can also quickly add a row by clicking in the lower-right cell of the table pressing the Tab key.

[Swati walia]

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact

DELETE FROM table_name;

or

DELETE * FROM table_name;

[Shubham Kumar]

Please confirm which database you are using.

so that I will let you know exact how to delete a row from a table ?

Thanks