HOME | PHP Tutorial | CSS
facebook icon
AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP
PHP Tutorial

PHP forms
HTML Tutorial

CSS 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

2817. PL/SQL Tutorial
We provide you with a comprehensive PL/SQL tutorial to help you learn PL/SQL quick and fun.
http://www.zentut.com/plsql-tutorial/

690. MySQL Tutorial - w3resource

https://www.w3resource.com/mysql/mysql-tutorials.php

2598. SQL tutorial will teach you how to use SQL - Database, sql tutorial
SQL tutorial will teach you how to use SQL - Database sql tutorial
http://www.agernic.com/sql-tutorial/sql-tutorials-sql-database.html

3228. SQL - Syntax, sql tutorial
SQL - Syntax sql tutorial
https://www.agernic.com/sql-tutorial/sql-syntax.html

2587. SQL Training - SQL Tutorial

http://www.sql-tutorial.net/sql-training.asp

2559. Copyright - SQL Tutorial

http://www.sql-tutorial.net/copyright.asp

Your add here
PHP strlen() function

PHP lcfirst() function

PHP strtoupper() function

PHP ltrim() function

PHP print() function

PHP explode() function

PHP str_split() function

PHP strstr() function

PHP similar_text() function

PHP md5() function

PHP ucfirst() function

PHP strcmp() function

PHP htmlspecialchars_decode() function

PHP strtolower() function

PHP htmlentities() function

PHP define() function

CSS rounded corners
HTML Table Rowspan and Colspan
HTML Text Size
SQL IN Operator - example
SQL update - SQL update select
HTML Text Color