MySQL DELETE Statement

MySQL DELETE Statement

MySQL DELETE statement is used to delete data from the MySQL table within the database. By using delete statement, we can delete records on the basis of conditions.

Syntax:

  1. DELETE FROM table_name
  2. WHERE
  3. (Condition specified);

Example:

  1. DELETE FROM cus_tbl
  2. WHERE cus_id = 6;

Output:

a1

For any query or issue, feel free to discuss on http://discuss.eduguru.in