Hi,
Maybe can be useful.MySQL suport and UDF.
But you can solve this problem in the next way:
@a:=0; -initialize variable a
select @a:MAX(YOUR_COLUMN_FROM TABLE) from YOUR_TABLE;
select @a:=@a+1;
insert into YOUR_TABLE SET YOUR_COLUMN_FROM TABLE= @a,bla,bla...;
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Scott Munday" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 9:18 PM
Subject: Suggestion on New MySQL Function
> Through your MySQL documentation, I wasn't able to find a function that I
> think could be useful. If you DELETE a row with an INT AUTO_INCREMENT
field,
> it will still be able to add the next highest value to this column on an
> INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five
> in its INT AUTO_INCREMENT column and the highest value for this particular
> INT column is currently six, your next INSERTed row will have a value of
> seven). This is very troubling for me, since at some point this INT will
> reach it's limit with 'holes' within the table. I think a function to find
> the lowest hole in a specified table would be a useful addition to further
> upgrades. Thank you for your time and patience.
> Sincerely,
> Trash Phantom
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
