mysql 设置保留两位小数

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    price DECIMAL(10, 2)
);

INSERT INTO products (name, price) VALUES ('Product A', 19.99);
INSERT INTO products (name, price) VALUES ('Product B', 29.95);

SELECT * FROM products;

INSERT INTO products (name, price) VALUES ('Product C', 19.9);

SELECT * FROM products;

id | name     | price
---|----------|-------
1  | Product A| 19.99
2  | Product B| 29.95
3  | Product C| 19.90

SELECT id, name, FORMAT(price, 2) AS formatted_price FROM products;

id | name     | formatted_price
---|----------|-----------------
1  | Product A| 19.99
2  | Product B| 29.95
3  | Product C| 19.90