MySQL ABS Function: Get Absolute Values

To obtain the absolute value in MySQL, you can use the ABS() function. This function returns the absolute value of a number, which is the value without the sign. For example, to get the absolute value of a column, you can use the following syntax:

SELECT ABS(column_name) FROM table_name;

This will return the absolute value of each value in the column. If you want to get the absolute value of a specific number or expression, you can use the ABS() function directly.

SELECT ABS(-10); -- 返回 10
SELECT ABS(-15.5); -- 返回 15.5
SELECT ABS(5*2); -- 返回 10