INST 327 Lecture Notes - Lecture 10: Mysql, Double-Precision Floating-Point Format, Binary Large Object
9 Sep 2018
School
Department
Course
Professor
Document Summary
Mysql uses all the standard ansi sql numeric data types, so if you"re coming to mysql from a different database system, these definitions will look familiar to you. The following list shows the common numeric data types and their descriptions . Int a normal-sized integer that can be signed or unsigned. If signed, the allowable range is from -2147483648 to 2147483647. If unsigned, the allowable range is from 0 to: you can specify a width of up to 11 digits. Tinyint a very small integer that can be signed or unsigned. If signed, the allowable range is from -128 to 127. If unsigned, the allowable range is from 0 to 255. You can specify a width of up to 4 digits. Smallint a small integer that can be signed or unsigned. If signed, the allowable range is from -32768 to 32767. If unsigned, the allowable range is from 0 to 65535.
