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.