4.4

The DELETE Clause

The DELETE Clause

  • You can delete single or multiple columns with a single statement.
  • You can use a subquery or a WHERE clause with a DELETE statement.
  • By default MySQL is in safe update mode which prevents coding a delete statement without a WHERE clause.

Code Example:

1    USE world;
2    DELETE 
3    FROM city 
4    WHERE name = 'san felipe' AND countrycode = 'chl';

Results:

iud_05.png

DELETE 

FROM city

WHERE name = 'san felipe' AND countrycode = 'chl';

This content is provided to you freely by EdTech Books.

Access it online or download it at https://edtechbooks.org/learning_mysql/the_delete_clause.