September 16th, 2008

DELETE

Posted by admin in E. INSERT, UPDATE, DELETE

Rows are DELETEd from the specified table when the condition statement is met.

DELETE all rows:             DELETE FROM table;

or

DELETE one or more rows:     DELETE FROM table
                              WHERE conditions;

> It is often convenient to test the WHERE clause with a SELECT statement to make sure the proper rows will be selected before using it in a DELETE.
> A subselect may be used to retrieve values for the WHERE clause.
> A subselect is a SELECT statement as described previously that has been attached to another SQL command.

Comments are closed.

Sorry, the comment form is closed at this time.