How to create a number type in MySQL?

In MySQL, you can create a column of type number using the following syntax:

CREATE TABLE table_name (
    column_name NUMBER
);

In this syntax, table_name is the name of the table you want to create, column_name is the name of the column you want to create, and NUMBER represents a numeric type column. You can set additional properties as needed, such as data length, decimal point position, etc.