On Mon, Jan 25, 2010 at 10:00 PM, Michael A. Peters 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. MyS
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 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 i
On Mon, Jan 25, 2010 at 18:51, 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
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 updat
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 wrote:
> Parham Doustdar wrote:
>
>> Hello there,
>> A friend called me today and was wondering what happens if the ID colomn
>> of an M
On Mon, Jan 25, 2010 at 17:15, 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!
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 t
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 ID'
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!
--
PHP General Mailing List (http://www.php.net/)
To unsubs
On Sat, 30 Mar 2002, Mantas Kriauciunas wrote:
> I have few users in my small page. And it goes with ID numbers. I
> did auto increasement. And i think all the settings are ok. but in
> phpMyAdmin it shows ID numbers starting from 5 and i have 10 users
> so when i deleted row(user) with ID
Hey [EMAIL PROTECTED],
I have few users in my small page. And it goes with ID numbers. I
did auto increasement. And i think all the settings are ok. but in
phpMyAdmin it shows ID numbers starting from 5 and i have 10 users
so when i deleted row(user) with ID number 9 i have id number goin
12 matches
Mail list logo
