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;