Delete

  • DELETE FROM <table_name> {WHERE condition}

  • TRUNCATE TABLE <table_name>

DELETE FROM `table_name` WHERE `column_name` = "Value"
DELETE FROM `table_name`
TRUNCATE TABLE `table_name`;

Notes:

  • TRUNCATE remove all records from the Table

Last updated