before you say a question, talk about table MySQL numeric type int. As is known to all, MySQL numeric type int accounts for four bytes, signed, unsigned shaped storage range, signed range-2147483648-2127483647, unsigned range is 0-4294967295 (2^32 is even, why here is odd, If not clear, please self-complement the computer bit operation). The display width of the integer value specified in parentheses following the MySQL type keyword (for example, INT (4)). The optional display width specifies that the width is filled from the left when the value that is less than the specified width of the column is displayed. The display width does not limit the range of values that can be saved within the column, nor does it limit the display of values that exceed the specified width of the column. Now look at Sequelpro's problem, the table is built to reflect the problem .
650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/85/25/wKiom1ea9qGiA55kAAIZ_-II7tk223.png-wh_500x0-wm_3 -wmp_4-s_3776463394.png "title=" QQ20160729-1@2x.png "alt=" Wkiom1ea9qgia55kaaiz_-ii7tk223.png-wh_50 "/>
Three fields are int, the only difference is the display width is inconsistent, is 1, 8, 11, and when I add data, the input box limits me
650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/85/25/wKiom1ea9z3il1dyAADg07Itksg561.png-wh_500x0-wm_3 -wmp_4-s_1698353264.png "title=" QQ20160729-2@2x.png "alt=" Wkiom1ea9z3il1dyaadg07itksg561.png-wh_50 "/>
But there's no problem with doing SQL add
650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/85/25/wKioL1ea98OAUiiXAAEtG2HgkeU863.png-wh_500x0-wm_3 -wmp_4-s_863218722.png "title=" QQ20160729-3@2x.png "alt=" Wkiol1ea98oauiixaaetg2hgkeu863.png-wh_50 "/>
This article is from the "I Believe" blog, please be sure to keep this source http://mrcelite.blog.51cto.com/2977858/1831699
About the Mac system Sequelpro tool for MySQL value type NT (M) stored value bug