- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Delete records from a MySQL table by excluding non-deleted records using NOT IN
Let us first create a table −
mysql> create table DemoTable ( FirstName varchar(100) ); Query OK, 0 rows affected (0.65 sec)
Insert some records in the table using insert command −
mysql> insert into DemoTable values('Chris'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Mike'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Sam'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('David'); Query OK, 1 row affected (0.12 sec)
Display all records from the table using select statement −
mysql> select *from DemoTable;
This will produce the following output −
+-----------+ | FirstName | +-----------+ | Chris | | Robert | | Mike | | Sam | | David | +-----------+ 5 rows in set (0.00 sec)
Following is the query to delete records from a MySQL table by excluding non-deleted records using NOT IN −
mysql> delete from DemoTable where FirstName NOT IN('Robert', 'Mike'); Query OK, 3 rows affected (0.17 sec)
Let us check the table records once again −
mysql> select *from DemoTable;
This will produce the following output −
+-----------+ | FirstName | +-----------+ | Robert | | Mike | +-----------+ 2 rows in set (0.00 sec)
- Related Articles
- Delete all records from a table in MySQL?
- Delete all the records from a MySQL table?
- Delete records from a MySQL table with IN() in a single query
- MySQL query to find single value from duplicates with certain condition by excluding other records using NOT IN
- Delete selective multiple records using MySQL DELETE query
- How to delete a single value from a MySQL table with duplicate records?
- How to delete all records from a table in Oracle using JDBC API?
- How to delete all the duplicate records in a MySQL table?
- Display table records from a stored procedure in MySQL
- MySQL query to find alternative records from a table
- Display selected records from a MySQL table with IN() operator
- A single MySQL query to insert records (not all) in the second table from the first table
- Inserting records into a MySQL table using PreparedStatement in Java?
- Count duplicates records in MySQL table?
- Order records and delete n rows in MySQL

Advertisements