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
It used to do what you are saying. That was very bad. For example, we
stored click data for articles. Whe the articles were archived for speed
reasons, MySQL started filling in the holes. When we got back around to
archiving those rows, we could not do so as the archive table already had
rows
Hello.
On Tue 2002-08-20 at 13:18:04 -0500, [EMAIL PROTECTED] wrote:
> 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 a
