DELETE FROM [ db.table | table ]
WHERE WhereClause
[ LIMIT LimitClause ]
The main use for this statement is to eliminate rows from the table/database combination that match a certain criteria (the WHERE clause). If no WHERE clause in specified, then ALL rows will be deleted. Only rows that fall into the LimitClause will be dropped.
NOTE- To have a complete look at the DELETE function, and any changes to its functionality, see the delete() function
| Home Back Forward Refresh txtSQL Homepage |
|
txtSQL Documentation > SQL Syntax > DELETE syntax
|
DELETE syntax
|
txtSQL >= 3.0.0 Beta |
|
||
| No comments posted yet; |
| Last Page | Next Page |
'Language Reference'
User Functions
Database Functions
Data Manipulation Functions
Table Functions
Error Handling Functions
SQL Syntax
SELECT Syntax
INSERT Syntax
DELETE syntax
UPDATE Syntax
CREATE DATABASE Syntax
DROP DATABASE Syntax
SHOW DATABASES Syntax
USE Syntax
LOCK Syntax
UNLOCK Syntax
IS LOCKED Syntax
CREATE TABLE Syntax
DROP TABLE Syntax
SHOW TABLES Syntax
DESCRIBE Syntax
SHOW USERS Syntax
GRANT PERMISSIONS Syntax
Column Properties
Column Types
LIMIT Syntax
ORDERBY Syntax
WHERE Syntax