All pages
Powered by GitBook
1 of 1

Loading...

Multiplication Operator (*)

Syntax

*

Description

Multiplication operator.

Examples

See Also

This page is licensed: GPLv2, originally from

Operator Precedence
Type Conversion
Addition Operator (+)
Subtraction Operator (-)
Division Operator (/)
fill_help_tables.sql
SELECT 7*6;
+-----+
| 7*6 |
+-----+
|  42 |
+-----+

SELECT 1234567890*9876543210;
+-----------------------+
| 1234567890*9876543210 |
+-----------------------+
|  -6253480962446024716 |
+-----------------------+

SELECT 18014398509481984*18014398509481984.0;
+---------------------------------------+
| 18014398509481984*18014398509481984.0 |
+---------------------------------------+
|   324518553658426726783156020576256.0 |
+---------------------------------------+

SELECT 18014398509481984*18014398509481984;
+-------------------------------------+
| 18014398509481984*18014398509481984 |
+-------------------------------------+
|                                   0 |
+-------------------------------------+