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) |
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Ask Questions? Discuss: Mysql Difference
Post your Comment