Home Sql Sql-functions Mysql Difference

Mysql Difference
Posted on: January 16, 2009 at 12:00 AM

Mysql Difference is used to return the records that are the outcome of difference between the records in a table.

Mysql Difference

Mysql Difference is used to return the records that are the outcome of difference between the records in a table.

Understand with Example

The Tutorial illustrate an example from 'Mysql Difference'.To understand this example we create a table 'Multiplication'.The table 'Multiplication' is created with required field name and datatype respectively.

Query for creating table name Multiplication:

mysql>  CREATE TABLE Multiplication(
    ->              a int(10),
    ->              b int(19),
    ->              c int(21)
    ->             );
Query OK, 0 rows affected (0.03 sec)

Query for Multiple insertion of data in table:

The Query insert into for inserting a multiple records or rows to the table 'Multiplication'.

mysql> insert into Multiplication (a,b,c)values
    ->                     (12,13,15),
    ->                     (22,23,25),
    ->                     (32,33,35),
    ->                     (42,43,45),
    ->                     (52,53,55),
    ->                     (62,65,64
Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query to view data inserted in table:

To view the records we use select query that returns you table details.

mysql> select * from multiplication;

Output:-

mysql> select * from multiplication;
+------+------+------+
| a    | b    | c    |
+------+------+------+
| 12   | 13   | 15   |
| 22   | 23   | 25   |
| 32   | 33   | 35   |
| 42   | 43   | 45   |
| 52   | 53   | 55   |
| 62   | 65   | 64   |
+------+------+------+
6 rows in set (0.00 sec)

Query to view Mysql difference of data inserted in table:

The below Query in Mysql is used to view difference of data inserted in a table 'Multiplication'.

mysql> select *,a-b  from multiplication ;

Output:-

+------+------+------+------+
| a    | b    | c    | a-b  |
+------+------+------+------+
| 12   | 13   | 15   | -1   |
| 22   | 23   | 25   | -1   |
| 32   | 33   | 35   | -1   |
| 42   | 43   | 45   | -1   |
| 52   | 53   | 55   | -1   |
| 62   | 65   | 64   | -3   |
+------+------+------+------+
6 rows in set (0.00 sec)

Related Tags for Mysql Difference:
sql, mysql, c, com, table, diff, sed, difference, return, tab, utc, if, record, records, to, between, e, use, ce, in, m, out, tween, me, s, urn, ee, etw, at, my, is, ha, ar, tco, rds, tw, s, s, rd, ren, th, ab, abl, hat, fe, om, o

«Previous Index Next»