What Is SQL DELETE Statement And How To Use

The SQL DELETE statement allows you to delete a single record or multiple records from a table.

The syntax for the SQL DELETE statement is:
DELETE FROM table WHERE predicates;

Simple example:
DELETE FROM Employee WHERE emp_name = 'BOB';
This SQL DELETE statement would Delete all records from the employees table where emp_name is BOB.

    Blogger Comment
    Facebook Comment
Copyright © 2013. New Techie - All Rights Reserved
Template Created by ThemeXpose