mysql DELETE statement

UK[dɪˈli:t] US[diˈlit]

vt.& vi.Delete

Third person singular: deletes Present participle: deleting Past tense: deleted Past participle: deleted

mysql DELETE statement syntax

Function: Used to delete rows in the table.

Syntax: DELETE FROM table name WHERE column name = value

mysql DELETE statement example

//删除person表中lastname为"wilson"的记录
DELETE FROM Person WHERE LastName = 'Wilson';
//删除表中所有数据
DELETE * FROM table_name;