SQL with Jupyter Notebook Tutorial

12 / 61

MySQL Data Types

MySQL database offers many data types to serve all kind of data storage and processing.

Numeric Types
MySQL uses all the standard ANSI SQL numeric data types.

  • INT - Signed from -2147483648 to 2147483647. Unsigned from 0 to 4294967295. Width of up to 11 digits.

  • TINYINT - Signed from -128 to 127. Unsigned from 0 to 255. Width of up to 4 digits.

  • SMALLINT - Signed from -32768 to 32767. Unsigned from 0 to 65535. Width of up to 5 digits.

  • MEDIUMINT - Signed from -8388608 to 8388607. Unsigned from 0 to 16777215. Width of up to 9 digits.

  • BIGINT - Signed from -9223372036854775808 to 9223372036854775807. Unsigned from 0 to 18446744073709551615. Width of up to 20 digits.

  • FLOAT(M,D) - Floating-point, unsigned, M -> total display length, D -> number of decimals, If (M,D) not given, defaults to (10,2), Decimal precision up to 24 places for a FLOAT.

  • DOUBLE(M,D) - Double Precision Floating-point, unsigned, M -> total display length, D -> number of decimals, If (M,D) not given, defaults to (16,4), Decimal precision up to 53 places for a FLOAT. Also called REAL.

  • DECIMAL(M,D) - Unpacked Floating-point, unsigned, M -> total display length, D -> number of decimals, If (M,D) not given, defaults to (16,4), Decimal precision up to 53 places for a FLOAT. Also called NUMERIC. In the unpacked decimals, each decimal corresponds to one byte.


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...