Numeric types


show more Numeric types provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training show less
please wait ...

Numeric types

MySQL Numeric Types include types for integer, fixed point and floating point real numbers. Integer types are used for storing numbers that don't have a fractional part. There are five integer types in MySQL and they differ only on the scale of the values that they represent. This table shows the storage requirements and scale for the various integer types. Note that int, is an alias for integer so when you see int or integer they mean exactly the same thing. The SQL standard is integer, but MySQL like most database systems recognizes int as the same type.

The decimal type is used for fixed precision values. The type declaration for decimal takes two parameters. The first parameter is the precision that specifies the number of digits that will be stored. This number includes the digits after the decimal point. The second parameter is the scale, this specifies the position of the decimal point. Zero means no decimal point. For example, this declaration has a 9 for precision and a 2 for scale, so there...

Numeric types
Video duration: 5m 21s 4h 24m Beginner

Viewers:

Numeric types provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training

Subject:
Developer
Software:
MySQL
Author:
please wait ...