Professional Web Applications Themes

What is the largest value that an autoincremented PK can get ? - MySQL

Hello, I would like to know what is the size of an integer value. What is the chances of a MyIsam table with an autoincremented field reaching the end ? What is the largest value that an autoincremented PK can get. Thanks a lot in advance....

  1. #1

    Default What is the largest value that an autoincremented PK can get ?

    Hello,
    I would like to know what is the size of an integer value.
    What is the chances of a MyIsam table with an autoincremented field
    reaching the end ?
    What is the largest value that an autoincremented PK can get.
    Thanks a lot in advance.

    Aggelos Guest

  2. #2

    Default Re: What is the largest value that an autoincremented PK can get ?


    Aggelos wrote: 
    And of course you have looked at the manual?
    http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
     
    To calculate this one would have to bring in factors such as the usage
    and longevity of the application. Bearing in mind the size that it can
    reach, I would guess at a very small probability.
     
    I would guess at 18446744073709551615 as long as the field is defined
    as BIGINT.
     
    You're welcome.

    Captain Guest

  3. #3

    Default Re: What is the largest value that an autoincremented PK can get ?


    Captain Paralytic wrote: 
    > And of course you have looked at the manual?
    > http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html[/ref]

    Thanks,
    I have looked in the manual but didn't found that table you posted for
    me :)
    There is always an answer in the manual .

    Thanks again.

    Aggelos Guest

Similar Threads

  1. Replies: 1
    Last Post: April 7th, 02:49 PM
  2. largest number - ASP
    By Jamesy in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 26th, 10:40 AM
  3. Largest process size under 2.7/2.8/2.9?
    By Frank D. Greco in forum Sun Solaris
    Replies: 8
    Last Post: July 25th, 04:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139