SQL Delete Table Data

SQL Delete rows from a table

like the other data modification statements, you can delete rows based on data in the table.

Syntax for SQL DELETE :
MySQL, Oracle, SQL server, PostgreSQL:
DELETE FROM table_name
WHERE search_conditions 
DELETE all rows in a table example:
DELETE FROM bookstore;
DELETE example with WHERE statement:
DELETE FROM bookstore
  where publisher='Addison Wesley';
© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the correctness in the pages or source codes.
The risk of using this web-site pages or any program codes from this website is entirely at the individual user.