Home Sql Mysql-example Mysql Multiplication Columns

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Multiplication Columns

Advertisement
Mysql Multiplication Columns is used to provide the column that is the outcome product of all the records in the respective columns of a table.

Mysql Multiplication Columns

     

Mysql Multiplication Columns is used to provide the column that is the outcome product of all the records in the respective columns of a table.

Understand with Example

The Tutorial describe you an example from 'Mysql Multiplication Columns'. To understand the example we simply create a table 'Multiplication' with required fieldname 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 for inserting a records or rows to the table 'Multiplication' is given below :

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:

The Query given below is used to return the records from table 'multiplication'.

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 multiplication of data inserted in table:

The below Query return you the result set in column 'Multiplication' as outcome product of records in the respective columns 

mysql> select a,b,c,a*b*c as Multiplication from multiplication;

Output:-

+------+------+------+----------------+
| a    | b    | c    | Multiplication |
+------+------+------+----------------+
| 12   | 13   | 15   | 2340           |
| 22   | 23   | 25   | 12650          |
| 32   | 33   | 35   | 36960          |
| 42   | 43   | 45   | 81270          |
| 52   | 53   | 55   | 151580         |
| 62   | 65   | 64   | 257920         |
+------+------+------+----------------+
6 rows in set (0.00 sec)
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 17, 2009

Related Tutorials

Discuss: Mysql Multiplication Columns  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com