The DELETE command

The DELETE command allows any records selected using WHERE to be removed from the specified table. However, if the whole table is selected, using DELETE * FROM table_name will delete the entire contents of the table:

DELETE FROM table_name 
    WHERE columncolumn_name2=9999