AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP, SQL
HTML Tutorial

SQL delete row - SQL delete table


SQL DELETE Query is used to delete an existing records from a table.
With SQL DELETE Query you can use the WHERE clause to delete the selected rows, otherwise all the records would be deleted from database table.

SQL delete row - SQL delete table - how to create? - example


Syntax The basic syntax of the DELETE query with WHERE clause is;
DELETE FROM name_table
WHERE [condition];



Example 1:
ID Name Contact Address City
1

Jones Cruise Ana Maria Will Str. 57 Paris
2 Robert Caine Ana Trujillo Avda. Larga 24 Roma
3 Brad Bale Antonio mauro Mataderos 19 Madrid

DELETE FROM Customers WHERE Name='Jones Cruise';

DELETE: Delete the first customer (ID = 1).

ID Name Contact Address City
2 Robert Caine Ana Trujillo Avda. Larga 24 Roma
3 Brad Bale Antonio mauro Mataderos 19 Madrid


If you want to DELETE all the records from the CUSTOMERS table in your database, you do not need to use the WHERE clause.

DELETE FROM Customers;

SQL statement from above deletes all rows in the - Customers - table, without deleting the table.

Note: Be careful when you are deleting records in a table!


sql delete, row, table, column, with join, table data, cascade, duplicates keep one, from multiple tables, rows in table, database
SQL delete row - SQL delete table - sql tutorial

Online Editor
ONLINE EDITOR

news templates


COLOR PICKER

news templates
This tool makes it easy to create, adjust, and experiment with custom colors for the web.


HTML Templates
news templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.


CSS HTML Layout
news templates
Find here examples of creative and unique website layouts.


Free CSS HTML Menu
news templates
Find here examples of creative and unique website CSS HTML menu.


Home - Database
SQL - Database
SQL Syntax
SQL Select Data
SQL Insert Data
SQL Update
SQL Delete Row
PHP mysqli_query()
SQL order
SQL Create Database
SQL Display Data
SQL Count()
SQL mysqli_connect
SQL create table
SQL Where And & Or
SQL like Syntax
SQL Between Operator
SQL IN Operator
Online Editor
ONLINE EDITOR

news templates


COLOR PICKER

news templates
This tool makes it easy to create, adjust, and experiment with custom colors for the web.


HTML Templates
news templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.


CSS HTML Layout
news templates
Find here examples of creative and unique website layouts.


Free CSS HTML Menu
news templates
Find here examples of creative and unique website CSS HTML menu.