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.

Back to Pagehome Tutorial Page

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


Ordering
Support
FAQ
Suggestions
Search
Resources
Prices
Brought to you by:
Great Southern Resources, Inc.
Copyright© 1997 All rights reserved.
 
All other products mentioned are registered trademarks or trademarks of their respective companies.

Questions or problems regarding this web site should be directed to webmaster@pagehome.com.