ホーム > 未分類 > [MySQL] int(11)の11は最大桁数ではない

[MySQL] int(11)の11は最大桁数ではない

危なかった。勘違いしてた。
int(11)の「11」って表示桁数を揃えるためのものであって、格納できるのはあくまで4バイトなんですね。
参照: 本家ドキュメント

試してみる。

mysql> create table int_test (id int(11) primary key);
Query OK, 0 rows affected (0.04 sec)
 
mysql> desc int_test;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | NO   | PRI | NULL    |       | 
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
 
mysql> insert into int_test values(2147483647);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into int_test values(2147483648);
ERROR 1062 (23000): Duplicate entry '2147483647' for key 1
カテゴリー: 未分類 タグ:
  1. 2020 年 5 月 30 日 09:46 | #1

    Everything is very open with a precise explanation of the challenges. It was definitely informative. Your website is very useful. Thank you for sharing!

  2. 2020 年 5 月 30 日 10:18 | #2

    I blog often and I genuinely appreciate your information. Your article has really peaked my interest. I’m going to bookmark your blog and keep checking for new information about once a week. I opted in for your RSS feed as well.

  3. 2020 年 5 月 30 日 10:31 | #3
  4. 2020 年 5 月 30 日 10:32 | #4

    An impressive share! I have just forwarded this onto a friend who was conducting a little homework on this. And he in fact bought me lunch because I discovered it for him… lol. So let me reword this…. Thanks for the meal!! But yeah, thanks for spending time to talk about this subject here on your internet site.

  5. 2020 年 5 月 30 日 11:06 | #5

    You should be a part of a contest for one of the most useful blogs on the internet. I’m going to recommend this blog!

  6. 2020 年 5 月 30 日 11:15 | #6

    I’m more than happy to find this site. I want to to thank you for ones time due to this wonderful read!! I definitely really liked every bit of it and i also have you book-marked to look at new stuff on your web site.

  7. 2020 年 5 月 30 日 11:49 | #7

    Howdy! This article could not be written any better! Reading through this post reminds me of my previous roommate! He constantly kept preaching about this. I am going to send this article to him. Pretty sure he’s going to have a very good read. I appreciate you for sharing!

  8. 2020 年 5 月 30 日 11:58 | #8

    Excellent write-up. I absolutely appreciate this site. Continue the good work!

  9. 2020 年 5 月 30 日 12:27 | #9

    Hi, I do think this is an excellent blog. I stumbledupon it ;) I may revisit yet again since i have saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to help others.

  10. 2020 年 5 月 30 日 12:37 | #10

    Good blog you have got here.. It’s hard to find high-quality writing like yours nowadays. I seriously appreciate individuals like you! Take care!!

  11. 2020 年 5 月 30 日 12:48 | #11

    I seriously love your site.. Very nice colors & theme. Did you develop this website yourself? Please reply back as I’m wanting to create my own blog and would like to know where you got this from or what the theme is named. Thanks!

  12. 2020 年 5 月 30 日 13:14 | #12

    This is a topic that’s close to my heart… Many thanks! Exactly where are your contact details though?

  13. 2020 年 5 月 30 日 13:15 | #13

    Howdy, I do believe your website may be having browser compatibility issues. Whenever I take a look at your blog in Safari, it looks fine however, when opening in IE, it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Besides that, fantastic website!

  14. 2020 年 5 月 30 日 13:41 | #14

    I wanted to thank you for this great read!! I absolutely loved every bit of it. I’ve got you bookmarked to look at new things you post…

  15. 2020 年 5 月 30 日 14:35 | #15

    Excellent site you have got here.. It’s difficult to find high-quality writing like yours nowadays. I really appreciate individuals like you! Take care!!

  16. 2020 年 5 月 30 日 15:06 | #16

    Hello! I could have sworn I’ve been to this web site before but after browsing through a few of the posts I realized it’s new to me. Anyhow, I’m certainly delighted I stumbled upon it and I’ll be book-marking it and checking back often!

  17. 2020 年 5 月 30 日 15:06 | #17

    This is a topic which is close to my heart… Best wishes! Where are your contact details though?

  18. 2020 年 5 月 30 日 15:13 | #18

    Excellent blog post. I certainly appreciate this website. Continue the good work!

  19. 2020 年 5 月 30 日 15:20 | #19

    Hi, I do think this is an excellent blog. I stumbledupon it ;) I may return yet again since I saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to help others.

  20. 2020 年 5 月 30 日 15:26 | #20

    I was very happy to find this great site. I want to to thank you for your time due to this fantastic read!! I definitely enjoyed every part of it and i also have you book-marked to look at new things in your website.

  21. 2020 年 5 月 30 日 16:06 | #21

    This site was… how do you say it? Relevant!! Finally I’ve found something that helped me. Many thanks!

  22. 2020 年 5 月 30 日 16:25 | #22

    Howdy this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding experience so I wanted to get guidance from someone with experience. Any help would be greatly appreciated!| а

  23. 2020 年 5 月 30 日 16:41 | #23

    This is a topic that’s close to my heart… Cheers! Where are your contact details though?

  24. 2020 年 5 月 30 日 16:51 | #24

    I blog often and I genuinely appreciate your information. This article has truly peaked my interest. I will bookmark your site and keep checking for new information about once a week. I subscribed to your Feed too.

  25. 2020 年 5 月 30 日 17:03 | #25

    Greetings! Very useful advice in this particular article! It is the little changes that will make the most significant changes. Thanks a lot for sharing!

  26. 2020 年 5 月 30 日 17:26 | #26

    Way cool! Some very valid points! I appreciate you writing this post and also the rest of the site is very good.

  27. 2020 年 5 月 30 日 17:27 | #27

    Good article. I’m facing a few of these issues as well..

  28. 2020 年 5 月 30 日 17:48 | #28

    Greetings! Very useful advice in this particular post! It is the little changes that produce the largest changes. Thanks a lot for sharing!

  29. 2020 年 5 月 30 日 17:56 | #29
  30. 2020 年 5 月 30 日 19:00 | #30

    Howdy! This blog post could not be written much better! Looking through this article reminds me of my previous roommate! He constantly kept talking about this. I am going to forward this post to him. Pretty sure he’s going to have a great read. Many thanks for sharing!

  31. 2020 年 5 月 30 日 19:12 | #31

    I’m impressed, I must say. Seldom do I come across a blog that’s both educative and interesting, and without a doubt, you have hit the nail on the head. The problem is an issue that too few people are speaking intelligently about. I’m very happy that I came across this during my hunt for something concerning this.

  32. 2020 年 5 月 30 日 19:31 | #32

    Hi there! This post couldn’t be written much better! Looking at this article reminds me of my previous roommate! He continually kept talking about this. I am going to forward this post to him. Fairly certain he’ll have a great read. Many thanks for sharing!

  33. 2020 年 5 月 30 日 19:33 | #33

    Hello, I do believe your blog could be having web browser compatibility issues. When I look at your website in Safari, it looks fine however, if opening in IE, it has some overlapping issues. I just wanted to give you a quick heads up! Besides that, fantastic blog!

  34. 2020 年 5 月 30 日 19:35 | #34

    Hi, I do think this is an excellent blog. I stumbledupon it ;) I may come back yet again since i have book marked it. Money and freedom is the best way to change, may you be rich and continue to guide others.

  35. 2020 年 5 月 30 日 20:07 | #35

    I quite like reading an article that can make men and women think. Also, thank you for permitting me to comment!

  36. 2020 年 5 月 30 日 20:23 | #36

    Hello there, I think your site could be having browser compatibility problems. Whenever I take a look at your site in Safari, it looks fine however, if opening in Internet Explorer, it’s got some overlapping issues. I simply wanted to give you a quick heads up! Other than that, wonderful site!

  37. 2020 年 5 月 30 日 21:04 | #37
  38. 2020 年 5 月 30 日 21:08 | #38

    There’s definately a lot to learn about this topic. I really like all of the points you made.

  39. 2020 年 5 月 30 日 21:20 | #39

    Howdy! I could have sworn I’ve been to this website before but after browsing through some of the articles I realized it’s new to me. Anyways, I’m definitely happy I stumbled upon it and I’ll be book-marking it and checking back frequently!

  40. 2020 年 5 月 30 日 21:31 | #40

    After I originally left a comment I appear to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I receive four emails with the exact same comment. Is there a means you are able to remove me from that service? Cheers!

コメントページ
1 59 60 61 225
  1. 2010 年 3 月 4 日 00:42 | #1
  2. 2020 年 4 月 14 日 10:03 | #2
  3. 2020 年 4 月 21 日 04:12 | #3
  4. 2020 年 4 月 28 日 02:02 | #4
  5. 2020 年 4 月 30 日 04:37 | #5
  6. 2020 年 4 月 30 日 12:32 | #6
  7. 2020 年 5 月 1 日 06:19 | #7
  8. 2020 年 5 月 2 日 19:33 | #8
  9. 2020 年 5 月 3 日 00:07 | #9
  10. 2020 年 5 月 3 日 06:22 | #10
  11. 2020 年 5 月 3 日 10:47 | #11
  12. 2020 年 5 月 4 日 06:33 | #12
  13. 2020 年 5 月 4 日 10:26 | #13
  14. 2020 年 5 月 4 日 15:19 | #14
  15. 2020 年 5 月 4 日 19:48 | #15
  16. 2020 年 5 月 5 日 01:00 | #16
  17. 2020 年 5 月 5 日 03:12 | #17
  18. 2020 年 5 月 5 日 07:28 | #18
  19. 2020 年 5 月 5 日 09:40 | #19
  20. 2020 年 5 月 5 日 10:44 | #20
  21. 2020 年 5 月 5 日 12:08 | #21
  22. 2020 年 5 月 5 日 15:14 | #22
  23. 2020 年 5 月 5 日 15:38 | #23
  24. 2020 年 5 月 5 日 18:29 | #24
  25. 2020 年 5 月 5 日 20:03 | #25
  26. 2020 年 5 月 5 日 21:16 | #26
  27. 2020 年 5 月 6 日 00:22 | #27
  28. 2020 年 5 月 6 日 01:11 | #28
  29. 2020 年 5 月 6 日 04:44 | #29
  30. 2020 年 5 月 6 日 05:15 | #30
  31. 2020 年 5 月 6 日 07:06 | #31
  32. 2020 年 5 月 6 日 08:43 | #32
  33. 2020 年 5 月 6 日 11:15 | #33
  34. 2020 年 5 月 6 日 12:00 | #34
  35. 2020 年 5 月 6 日 13:01 | #35
  36. 2020 年 5 月 6 日 13:11 | #36
  37. 2020 年 5 月 6 日 17:35 | #37
  38. 2020 年 5 月 6 日 20:19 | #38
  39. 2020 年 5 月 7 日 08:53 | #39
  40. 2020 年 5 月 7 日 17:24 | #40
  41. 2020 年 5 月 7 日 20:37 | #41
  42. 2020 年 5 月 7 日 20:51 | #42
  43. 2020 年 5 月 7 日 23:50 | #43
  44. 2020 年 5 月 8 日 00:22 | #44
  45. 2020 年 5 月 8 日 03:49 | #45
  46. 2020 年 5 月 8 日 05:34 | #46
  47. 2020 年 5 月 8 日 05:55 | #47
  48. 2020 年 5 月 8 日 08:36 | #48
  49. 2020 年 5 月 8 日 10:34 | #49
  50. 2020 年 5 月 8 日 11:02 | #50
  51. 2020 年 5 月 8 日 11:50 | #51
  52. 2020 年 5 月 8 日 15:31 | #52
  53. 2020 年 5 月 8 日 17:31 | #53
  54. 2020 年 5 月 8 日 23:16 | #54
  55. 2020 年 5 月 9 日 00:57 | #55
  56. 2020 年 5 月 9 日 06:28 | #56
  57. 2020 年 5 月 9 日 09:10 | #57
  58. 2020 年 5 月 9 日 12:59 | #58
  59. 2020 年 5 月 9 日 13:17 | #59
  60. 2020 年 5 月 9 日 18:41 | #60
  61. 2020 年 5 月 17 日 03:50 | #61
  62. 2020 年 5 月 17 日 05:07 | #62
  63. 2020 年 5 月 17 日 06:57 | #63
  64. 2020 年 5 月 18 日 19:09 | #64
  65. 2020 年 5 月 18 日 19:11 | #65
  66. 2020 年 5 月 18 日 19:57 | #66
  67. 2020 年 5 月 19 日 18:49 | #67
  68. 2020 年 5 月 21 日 07:13 | #68
  69. 2020 年 5 月 23 日 00:41 | #69
  70. 2020 年 5 月 23 日 02:22 | #70
  71. 2020 年 5 月 23 日 20:06 | #71
  72. 2020 年 5 月 23 日 20:32 | #72
  73. 2020 年 5 月 24 日 05:20 | #73
  74. 2020 年 5 月 24 日 06:46 | #74
  75. 2020 年 5 月 24 日 17:28 | #75
  76. 2020 年 5 月 24 日 18:15 | #76
  77. 2020 年 5 月 24 日 22:01 | #77
  78. 2020 年 5 月 25 日 01:12 | #78
  79. 2020 年 5 月 25 日 01:20 | #79
  80. 2020 年 5 月 25 日 06:16 | #80
  81. 2020 年 5 月 25 日 07:45 | #81
  82. 2020 年 5 月 25 日 09:16 | #82
  83. 2020 年 5 月 25 日 09:35 | #83
  84. 2020 年 5 月 25 日 16:13 | #84
  85. 2020 年 5 月 25 日 23:58 | #85