MySQL Delete


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

grammar:

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.

Example

DELETE FROM user WHERE username = 'Jack'



Copyright 2014-2017 by DeveloperTut.com. All Rights Reserved.
TwitterGoogle+Facebook