My Training Notes & Blog

Using Numeric Functions in MySQL

Published on: July 26, 2025 | Published by: Sai Sreeram Gundepudi

Examples

SELECT ROUND(123.456, 2);
SELECT CEIL(9.1);
SELECT FLOOR(9.9);
SELECT MOD(10, 3);
SELECT POWER(2, 3);