Shulou(Shulou.com)06/02 Report--

This article will explain in detail what the field types of MySql are, and the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Field type:

TINYINT- is a small integer. The signed range is-128 to 127 and the unsigned range is 0 to 255.

SMALLINT- a small integer. The signed range is-32768 to 32767 and the unsigned range is 0 to 65535.

MEDIUMINT- a medium-sized integer. The signed range is-8388608 to 8388607 and the unsigned range is 0 to 16777215.

INT---- is a normal size integer. The signed range is-2147483648 to 2147483647 and the unsigned range is 0 to 4294967295.

A synonym for INTEGER-INT.

BIGINT- a large integer. The signed range is-9223372036854775808 to 9223372036854775807, and the unsigned range is 0 to 18446744073709551615.

FLOAT- a small (single precision) floating point number. Can't be unsigned. The allowed values are-3.402823466E+38 to-1.175494351Emury38Power0 and 1.175494351E-38 to 3.402823466E+38. M is the number of digits in which width is displayed and D is the decimal. FLOAT with no parameters or have

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.