Home Sql Sql-functions Mysql Multiplication Columns



Mysql Multiplication Columns
Posted on: January 16, 2009 at 12:00 AM
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)

Related Tags for Mysql Multiplication Columns:
sqlmysqlccomidetableiosedcolumnipvicolumnsidtabutcrecordrecordstoproductemultimultiplicationliuseulpeinmoutcaesspecallmeprocatumnsrespecttipspespcolatmyishallivdutcordsssrdthabablatihatlumiplicaicaplprodpronomolo


More Tutorials from this section

Ask Questions?    Discuss: Mysql Multiplication Columns   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

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.