PHP Tutorials
- What is MySqli
- mysql query
- mysql query example
- InnoDB
- mysql column Type
- CRUD Example
- Connection Using Function
- mysql keys
- SELECT
- WHERE
- UPDATE
- Count no of Rows
- ALIAS
- AND, AND & OR
- BETWEEN
- COMPARISON OPERATOR
- DELETE
- DELETE LIMIT
- DISTINCT
- EXISTS
- FROM
- GROUP BY
- HAVING
- IN
- INTERSECT
- IS NULL & IS NOT NULL
- LIKE
- NOT
- ORDER BY
- SELECT LIMIT
- SUBQUERY
- TRUNCATE
- UNION && UNION ALL
- Concat & Group_Concat
- mysql Function
- Mysql Insert Id
- MySql Aggregate Function
- Mysql Join
- JOIN in MySql
- Trigger
- Procedure
- Transaction
- views
- Index
- SQL Injection
- Normalization
- Query Bind
- Interview Questions
Important Link
SeleteStatement in mysql
The MySQL DELETE statement is used to delete a single record or multiple records from a table in MySQL.
With One condition
DELETE FROM contacts
WHERE last_name = 'Johnson';
With Two conditions
DELETE FROM contacts
WHERE last_name = 'Johnson'
AND contact_id < 1000;
With LIMIT modifier
DELETE FROM contacts
WHERE last_name = 'Johnson'
ORDER BY contact_id DESC
LIMIT 1;
DELETE FROM contacts
ORDER BY contact_id DESC
LIMIT 1;
Using EXISTS Condition
DELETE FROM suppliers
WHERE EXISTS
( SELECT *
FROM customers
WHERE customers.customer_id = suppliers.supplier_id
AND customer_id > 500 );