截断你的答案到小数位mysql

截断你的答案到小数位mysql

SELECT TRUNCATE(135.375, 2);   -- Result: 135.37

SELECT TRUNCATE(COLUMN_NAME, X) FROM TABLE;
-- Truncate values in the COLUMN_NAME upto X decimal places