*

Perkalian:

Syntax

MYSQL Copy

SELECT 3*5;
15
SELECT 18014398509481984*18014398509481984.0;
324518553658426726783156020576256.0
SELECT 18014398509481984*18014398509481984;
out-of-range error

Contoh

Example

The last expression produces an error because the result of the integer multiplication exceeds the 64-bit range of BIGINT calculations. (See Section 13.1, “Numeric Data Types”.)

MYSQL Copy

SELECT 3*5;
15
SELECT 18014398509481984*18014398509481984.0;
324518553658426726783156020576256.0
SELECT 18014398509481984*18014398509481984;
out-of-range error