kidsferro.blogg.se

xReal, Double: Floating point number in double precision.

Float: Small number in single-precision floating point.No sign, the range of values ​​is 0 to 429 496 295 Integer, Int: Integer with or without sign.No sign, the value range is 0 to 16777215. MediumInt: Integer with or without sign.No sign, the range of values ​​is 0 to 65535. Sign with a valid range of values ​​is from -32768 to 32767. SmallInt: Integer with or without sign.Bit ou Bool: Integer that can be 0 or 1, widely used when need to perform validations and conditional (true and false).No sign, the range of values ​​is 0 to 255 Sign with a valid range of values ​​is from -128 to 127. TinyInt: Integer with or without sign.This data type is used when you need to store numbers and they integer or decimal. In MySQL there are three major groups of data they are numeric, date and text. So let us know in the string data types that MySQL and so help you choose the best option when creating your tables and model your bank. Each column will be assigned a name and what kind of data you will store and for each type of information is required to indicate a compatible data type. When creating a table is necessary to inform the columns that will be part of it as well as the type of data that will be stored.