Some of the MySQL built-in datatypes are listed below:
|
|
DATE- Date fields or time information like '24-09-2022'. There are several date formats and the standard date format for input and output is 'DD-MON-YY', e.g., '01-JAN-23'.
INTEGER- Integer number
NUMBER- The storage of both fixed and floating point number by using the format
NUMBER(precision, scale), where precision is the total number of digits and scale is the number of digits to right of decimal point. For the example of “amount number(5,2)”, 123.46 is valid, and 12345 is invalid. REAL- Real number
SMALLINT- Short integer
VARCHAR- It is the same as
VARCHAR2. VARCHAR2- Variable-length strings.
It was used before the
VARCHARdefinition is finalized.
|
Lend an ear (Listen), and I’lll tell you what people said at the meeting yesterday. |