It will continue to use the max number which of course will cause an error.
Joseph
Parham Doustdar wrote:
Hello there,
A friend called me today and was wondering what happens if the ID colomn of
an MYSQL database, set to autoinc reaches the int limit. Will it return and
begin choosing the
Parham Doustdar wrote:
Hello there,
A friend called me today and was wondering what happens if the ID colomn of
an MYSQL database, set to autoinc reaches the int limit. Will it return and
begin choosing the ID's that have been deleted, or... what?
Thanks!
Ask Slashdot... I believe they hit
On Mon, Jan 25, 2010 at 17:15, Parham Doustdar parha...@gmail.com wrote:
Hello there,
A friend called me today and was wondering what happens if the ID colomn of
an MYSQL database, set to autoinc reaches the int limit. Will it return and
begin choosing the ID's that have been deleted, or...
For such a large data set, they would split into several sub tables,
otherwise the performance will be horrible
On Mon, Jan 25, 2010 at 3:39 PM, Robert Cummings rob...@interjinn.comwrote:
Parham Doustdar wrote:
Hello there,
A friend called me today and was wondering what happens if the ID
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the closest value.
3. MySQL will then try and insert the new row with the
On Mon, Jan 25, 2010 at 18:51, Joseph Thayne webad...@thaynefam.org wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater than
the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the
Joseph Thayne wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the closest
value.
3. MySQL will then try and insert
Shawn McKenzie wrote:
Joseph Thayne wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will see this as a problem and truncate it to the closest
value.
3. MySQL will then
On Mon, Jan 25, 2010 at 10:00 PM, Michael A. Peters mpet...@mac.com wrote:
Shawn McKenzie wrote:
Joseph Thayne wrote:
That is incorrect. What will happen is as follows:
1. The value will be incremented by 1 causing the value to be greater
than the maximum integer allowed.
2. MySQL will
9 matches
Mail list logo