Uhm, I was actually in favor of auto_increment fields... auto_increment
should protect against data inconsistency by providing a unique and new
number for new data so it does not "inherit" old data (in other tables).
If you really wanted to do your own auto_increment, it wouldn't be hard,
but why add code when the database can do that for you? Just do a select
max(`id`) from `tablename`, although that wouldn't find an open one.
Combining data from two tables with auto_increment fields sounds dangerous
and a prime candidate for inserting consistency errors.
-Dash
The hardest thing in the world to understand is the income tax.
-- Albert Einstein
On Sat, 18 Jan 2003, Cam Dunstan wrote:
>
> Amen to that - I really believe you are better off (if you have the freedom
> to do so) changing autoincrement fields to an integer type and managing the
> incrementing yourself. In addition to the problem Dash mentions there is
> yet another "gotcha" - if you are ever faced with having to combine two
> tables of existing data, each with an autoincrement fields you have a
> serious problem on your hands and a lot of sweat work to change all the
> related tables before you combine them. If I was Prime Minister I would
> immediately pass legislation outlawing autoincrement fields ( my chances are
> not good however).
>
>
>
> ----- Original Message -----
> From: "Dash McElroy" <[EMAIL PROTECTED]>
> To: "Piotr Pluciennik" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Saturday, January 18, 2003 4:54 AM
> Subject: Re: [PHP-WIN] SQL-query
>
>
> > Piotr is right. SQL shouldn't let you do that, if only for possible
> > consistency errors. Imagine if you had id 3 referenced in some other table
> > and then you put new data in the primary table with id of 3. Then all the
> > other stuff referring to 3 would then refer to the new data. Not a good
> > thing.
> >
> > I've been digging through an SQL book lately... some mind bending (but
> > extremely logical) information.
> >
> > -Dash
> >
> > Don't look back, the lemmings are gaining on you.
> >
> > On Fri, 17 Jan 2003, Piotr Pluciennik wrote:
> >
> > > Hi,
> > >
> > > I don't use MYSQL, but the problem is common for
> > > databases. One of the idea of auto increment field is
> > > to have unique identifiers, so you can't insert a
> > > record with auto increment fields set by yourself.
> > > It's always done by DB. So you can't fill a "hole" in
> > > numbering after deleting record. Of course in a normal
> > > way of using DB... :-)
> > >
> > > HTH
> > >
> > > Piotr
> > >
> > > --- Bobo Wieland <[EMAIL PROTECTED]> wrote:
> > > > I hope this isn't to much OT... Sorry if it is...
> > > >
> > > > In my MySQL-db that I use for a php-driven site I
> > > > have many tables with the
> > > > Primary Key set as an auto increment value.
> > > >
> > > > If I have 4 records with id 1, 2, 3 and 4 and then
> > > > delete number 3 and add
> > > > one more record I get the id's 1,2,4 and 5. It isn't
> > > > much of a problem, but
> > > > it would be nice to check for the first "hole" in
> > > > the id's and insert the
> > > > record there instead. How would you do this? is
> > > > there some simple way from
> > > > either MySQl or PHP that doesn't take to much time
> > > > to execute?
> > > >
> > > > thanks in advance
> > > >
> > > >
> > > > . bobo . www.elstudion.com . [EMAIL PROTECTED] .
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Windows Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > >
> > >
> > > __________________________________________________
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > > http://mailplus.yahoo.com
> > >
> > > --
> > > PHP Windows Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
