The difference between MySQL int (3) and int (11)Note: M here is not a specific length stored in the database, it was always mistaken for int (3) to store only 3-length numbers, and int (11) would store 11-length numbers, which is a big
Summing up, int (m) Zerofill, plus Zerofill after M to show a little bit of effect, such as int (3) Zerofill, you inserted into the database is 10, then the actual insert is 010, that is, add a 0 in front. if int (3) and int (10) Without Zerofill,
NT (M) let's first split, int is representing integer data so the middle of the M should represent how many bits, and later the MySQL handbook also learned that my understanding is correct, I would like to illustrate.The integer types in the MySQL
The difference between a MySQL int (3) and an int (11)
Summing up, int (m) Zerofill, plus zerofill after M to show a little bit of effect, such as int (3) Zerofill, you insert into the database is 10, then the actual insertion of 010, that is, add
Summing up, int (m) Zerofill, plus Zerofill after M to show a little bit of effect, such as int (3) Zerofill, you inserted into the database is 10, then the actual insert is 010, that is, add a 0 in front. if int (3) and int (10) Without Zerofill,
Summing up, int (m) Zerofill, plus Zerofill after M to show a little bit of effect, such as int (3) Zerofill, you inserted into the database is 10, then the actual insert is 010, that is, add a 0 in front. if int (3) and int (10) Without Zerofill,
Mysql int (3) and int (11) Differences, mysqlint
Difference between mysql int (3) and int (11)
In summary, int (M) zerofill, followed by zerofill, then M shows a little effect. For example, if int (3) zerofill is inserted into the database as 10, it
Information A
1, stop the database server, the database MDF files and LDF files copy backup a copy
2, start the database server, delete the suspect database
3, only with the backup of the database MDF file attached to the database,
Int (m) Zerofill, plus Zerofill after M shows a little bit of effect,For example int (3) Zerofill, you insert into the database is 10, then the actual insert is 010, that is, add a 0 in front of theif int (3) and int (10) are not zerofill, they are
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.