PHPDocs.COM
  • Home
  • HTML
  • CSS
  • PHP
  • SQL
  • Video Tutorials
    WordPress WooCommerce Arduino Raspberry PI



SQL

  • Introduction to SQL
  • INSERT Statement
  • UPDATE Statement
  • DELETE Statement

Select Statements

  • SELECT Statement
  • SELECT DISTINCT
  • SELECT WHERE
  • SELECT AND, OR, Not
  • SELECT Order By
  • Null Values
  • SELECT Top
  • SELECT Min, Max
  • SELECT Count, Avg, Sum
  • SELECT Like

SQL
DELETE Statement

DELETE statement is used to delete the records of a table.

Basic Syntax

Copy Code Copied Use a different Browser

 

	DELETE FROM table_name WHERE condition; 

Example

Specific Record

If you want to delete a specific customer details from customer table:

Copy Code Copied Use a different Browser

 

    DELETE FROM Customers WHERE CustomerName='john';

All Record

If you want to delete all the records of customer table:

Copy Code Copied Use a different Browser


    DELETE FROM Customers;

SQL

Copyright © PHPDocs 2017