MySQL FORMAT Function: Examples

SELECT FORMAT(12500.2015, 0);

SELECT FORMAT(12500.2015, 2,'de_DE');

SELECT 
    productname, quantityInStock * buyPrice stock_value
FROM
    products;

SELECT productname,
         CONCAT('$', FORMAT(quantityInStock * buyPrice, 2)) stock_value
FROM products;

SELECT productname,
         CONCAT('$', FORMAT(quantityInStock * buyPrice, 2)) stock_value
FROM products
ORDER BY  stock_value;

SELECT productname,
         CONCAT('$', FORMAT(quantityInStock * buyPrice, 2)) stock_value
FROM products
ORDER BY  quantityInStock * buyPrice;

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;