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.