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

Related Tags for MySQL Not equal:
sql,  mysql,  c,  table,  io,  sed,  return,  set,  tab,  if,  condition,  ie,  record,  where,  records,  to,  base,  ci,  e,  it,  not,  use,  pe,  from,  in,  no,  as,  m,  os,  clause,  os,  based,  cl,  spec,  ase,  equal,  s,  urn,  sp,  my,  is,  rds,  s,  s,  rd,  th,  cond,  ab,  abl,  nd,  only,  on,  om,  o,  nl

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: MySQL Not equal  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):