MySQL Delete

The DELETE FROM syntax is used to delete data records from a data table.


DELETE FROM tb_name WHERE conditions

This syntax deletes the data records that match the WHERE condition in the data table. If you omit the WHERE condition, all the records in the table are deleted.


DELETE FROM user WHERE username = 'Jack'

Copyright 2014-2017 by All Rights Reserved.