27;George Pitcher'
> Subject: RE: [PHP-WIN] SQL query problem
>
>
> Try this: Pack.End > "'.date("Y-m-d").'"
>
> be sure that you have the same dateformat
>
>
>
>
> Hi,
>
> I'm having a problem with the following query (OD
t;[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 11:29 AM
Subject: RE: [PHP-WIN] SQL-query
> Why the hell would you want to do that?
>
> It looks ugly?
>
> I'll tell you what, when you have 8 records in the database, and
#34,501
> is missing, I wonder if you'
Why the hell would you want to do that?
It looks ugly?
I'll tell you what, when you have 8 records in the database, and #34,501
is missing, I wonder if you'll notice, or want to write code to fill, the
"hole"
if you really want to fix the hole (as much as I think you are seriously
wasting yo
;[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
EMAIL PROTECTED]
Subject: Re: [PHP-WIN] SQL-query
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 &q
es 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.
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'
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
