Detailed SQL DELETE statement

DELETE statement

The DELETE statement is used to delete rows in a table.

Grammar

DELETE from table name WHERE column name = value

Person: City

LastName	FirstName	Address
Gates	Bill	Xuanwumen 10	Beijing
Wilson	Fred	Zhongshan 23	Nanjing

Delete a row

"Fred Wilson" will be removed:

Results: City

LastName	FirstName	Address
Gates	Bill	Xuanwumen 10	Beijing

Delete all rows

You can delete all rows without deleting the table. This means that the structure, properties, and indexes of the table are complete:

DELETE from table_name

Or:

DELETE * FROM table_name

Detailed SQL DELETE statement