MySQL Not equal
MySQL Not equal is used to return the set of only those records from a table based on the condition specified in the Where Clause.
Query for creating table name Employee:
The create table is used to create a table Employee which has required fieldnames and its datatype respectively.
mysql> CREATE TABLE Employee( -> Empid int(10), -> Empname varchar(60), -> Salary int(90), -> DOB date -> ); Query OK, 0 rows affected (0.01 sec) |
Query for insertion of data in table:
The insert into is used to add the records to table 'Employee'.
mysql> INSERT INTO Employee (Empid,Empname,Salary,DOB) VALUES -> (01,'Habib',2014,20041202), -> (02,'Girish',4021,20030411), -> (03,'Samia', 22,20080223), -> (04,'Hui Ling', 25,20081015), -> (05,'Yumie', 29,19990126); Query OK, 5 rows affected (0.00 sec) Records: 5 Duplicates: 0 Warnings: 0 |
Query to view data inserted in table:
The Query select is used to return the records from table 'employee'.
mysql> select * from employee; |
Output:
+-------+----------+--------+------------+ | Empid | Empname | Salary | DOB | +-------+----------+--------+------------+ | 1 | Habib | 2014 | 2004-12-02 | | 2 | Girish | 4021 | 2003-04-11 | | 3 | Samia | 22 | 2008-02-23 | | 4 | Hui Ling | 25 | 2008-10-15 | | 5 | Yumie | 29 | 1999-01-26 | +-------+----------+--------+------------+ 5 rows in set (0.00 sec) |
Query to use MySQL not equal :
The Query MySQL not equal returns only those records from table 'employee' whose employee name and salary are not equal to 'Girish' and '4021'.
mysql> select * from employee where Empname!='Girish' -> and salary!=4021; |
Output:-
+-------+----------+--------+------------+ | Empid | Empname | Salary | DOB | +-------+----------+--------+------------+ | 3 | Samia | 22 | 2008-02-23 | | 4 | Hui Ling | 25 | 2008-10-15 | | 5 | Yumie | 29 | 1999-01-26 | +-------+----------+--------+------------+ 3 rows in set (0.02 sec |