mSQL Tutorial 2

The "Delete" clause

The delete clause deletes an entry from the field of a database table.

The format for the delete clause looks like this:

DELETE FROM table_name
WHERE column OPERATOR value
[ AND | OR column OPERATOR value ]**

OPERATOR can be <,>, =, <=,>=, , or like

So to give you an idea of how this works, a working example:

DELETE FROM emp_details WHERE emp_id = 12345

In this example we are removing from table "emp_details" and field "emp_id" the value of "12345". The most common use for this would be if you have inserted the wrong data into a field. Using this method you can undo that mistake which allows you to go back in and re-insert that data.

And now one of the most useful functions of mSQL, The "Select" clause.