How to delete row in mysql with example

if you want to delete data in mysql table than use following syntax

Syntax:-

DELETE FROM table_name WHERE position_of_row;

Note:-

# Entire row will be deleted.

# Position of row is required, because if you forget to write position_of_row than mysql will delete entire table.

Example:-

If you want to delete homeno 27 than syntax will be

DELETE FROM homedetails WHERE homeno=27;

2. same homeno

DELETE FROM homedetails WHERE state='punjab' and country='pakistan';

3. Delete all rows

Syntax:-

DELETE FROM table_name;

or

DELETE * FROM table_name;

Example:-

DELETE FROM homedetails;

homeno

homename

state

country

Previous Code:-
Add multiple row

List Code:-
Mysql Codes

Next Code:-
Rename table name

Add your comments here

About Codes