Entry

Database: Language: SQL: Table: Operation: Remove: How to delete data from a table?

Mar 20th, 2005 02:39
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 20 March 2005 - 04:22 pm ----------------------

Database: Language: SQL: Table: Operation: Remove: How to delete data 
from a table?

---

Use the SQL command:

 DELETE FROM <your table name>

---
---

-----------------------------------------------
DELETE FROM
 <mytable>
WHERE
 <columnname1> = '<value1>'
AND / OR
 <columnname2> = '<value2>'
AND / OR
 <columnname3> = '<value3>'
...
AND / OR
 <columnnameN> = '<valueN>'
;
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
DELETE FROM
 <your tablename>
WHERE
 <your expression>
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
DELETE FROM
 customer
WHERE
 customername="Knud"
;
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
DELETE FROM
 email
WHERE
 ( emailaddress = 'mail@mydomain.com' )
;
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
DELETE FROM
 tableAddressS
WHERE
 columnFirstNameS = 'Knud'
AND
 columnLastNameS = 'van Eeden'
;
-----------------------------------------------

---
---

Note:

Do not use '*' after DELETE,

e.g.

DELETE * FROM email WHERE (emailaddress = 'mail@mydomain.com')

will give a syntax error.

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------