Low Orbit Flux Logo 2 D

How to Multiply in MySQL

It is extremely easy to multiply in MySQL. You basically just use the * operator between two columns in a select statement. This isn’t really specific to MySQL. It just uses basic SQL syntax. Here is a really basic example:

SELECT name, price*quantity  
AS total FROM items;

This is assuming you have a table named “items” with the following columns:

Here is another example in which we just multiply a column by a number.

SELECT name, price*2  
AS total FROM items;

Here we have yet another example where we multiply two columns from different tables.

SELECT p.name, i.price*d.quantity AS total
FROM items i
JOIN distribution d ON d.id=p.d_id;