= 65535
# MEDIUMTEXT = 16777215
# LONGTEXT = 4294967295
DÆVID
> -Original Message-
> From: Daniel Kasak [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 13, 2006 9:52 PM
> To: wolverine my; mysql@lists.mysql.com
> Subject: Re: Reset (or Defrag) the AUTO_IN
Hi wolverine,
of course you could "defrag" your autoincrement-values, but there's
no automation for that - you've do do that via normal insert/update
statements.
Perhaps you'll need an intermediate table.
But:
In most cases the autoincrement-value is used as an id (as in your case)
- in
db-langua
wolverine my wrote:
> Yes, I agree on what you have described.
>
> However, what should we do when the value is reaching the maximum? To
> alter the data type to a bigger one?
Yes - convert the data type to a larger one.
If you've got a mediumint, for example, you can convert it to an
unsigned m
Yes, I agree on what you have described.
However, what should we do when the value is reaching the maximum? To
alter the data type to a bigger one?
On 6/14/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:
wolverine my wrote:
> May I know if there is any way we can reset (or defrag?) the values
Yo
wolverine my wrote:
> May I know if there is any way we can reset (or defrag?) the values
You shouldn't do that. It's much easier for you as a database
administrator if these values are left up to MySQL.
What happens, for example, if you restore from a backup that has rows
which you recently del
