MySQL DECIMAL Type: Complete Usage Guide

In MySQL, the Decimal type can be assigned using the following syntax:

CREATE TABLE table_name (
    column_name DECIMAL(precision, scale)
);

INSERT INTO table_name (column_name) VALUES (value);

In this case, precision refers to the total number of digits, while scale indicates the number of decimal places. For example, DECIMAL(10, 2) represents a total of 10 digits, with 2 of them being decimals.

“我不知道明天会发生什么。”
I don’t know what will happen tomorrow.

CREATE TABLE products (
    price DECIMAL(10, 2)
);

INSERT INTO products (price) VALUES (19.99);

This will assign the value 19.99 to the price column.