[Home]  [Edit this page]  [Recent Changes]  [Special Pages]  [Help] 

---

SQLDelete

---

(SQL) DELETE

There are two forms of DELETE:

• Deletes a table
• Deletes records in a table

Deleting a table

DELETE  tablename

Deleting records in a table

DELETE FROM tablename
WHERE Condition
LIMIT MaxRecordsToDelete

Condition has the same syntax as in SELECT and UPDATE queries. If none is supplied, it deletes all records in a table (or all upto the LIMIT if one is given). The query returns the number of records that were deleted.


[Edit this page]  [Page history]  [What links here]  [Discuss this topic]  [Printer Friendly]