Mysql shaping length
- int

From where? -2^3 1?

(-2, 147,483,648)? Arrive? 2^3 1? –? 1? (2, 147,483,647)? Integer data (all numbers) of. What is the storage size? 4? Bytes int? what's up SQL-92?

What are synonyms? Integer.

- ? bigint

From where? -2^63? (-9223372036854775808)? Arrive? 2^63- 1?

(9223372036854775807)? Integer data (all numbers) of. What is the storage size? 8? Bytes ?

Ps?

Bigint already has a length. Is the length in mysql table only the number of digits for display?

- ? smallint?

From where? -2^ 15? (-32,768)? Arrive? 2^ 15? –? 1? (32,767)? Integer data of. What is the storage size?

2? Bytes ?

- ? tinyint

From where? 0? Arrive? 255? Integer data of. What is the storage size? 1? Bytes?

- ? Where are integer values supported? bigint? Data type. However, bigint is used in some special cases when the integer value exceeds? int? Data type support range, can use? bigint?

- ? In the data type priority table, bigint? Located? Small money? And then what? int? Between?

Only if the parameter expression is. bigint? Data type, function return?

bigint .?

- ? int(M)? Are you online? Integer? In data type, m? Represents the maximum display width. Are you online? int(M)? Medium, m? What is the value of? int(M)? It doesn't matter how much storage space you take up. It has nothing to do with digits? int(3)、int(4)、int(8)? Is it occupied on the disk? 4? btyes? Storage space of.