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表中l(wèi)astname為"wilson"的記錄
DELETE FROM Person WHERE LastName = 'Wilson';
//刪除表中所有數(shù)據(jù)
DELETE * FROM table_name;