Andrew Kreps wrote:
...
20050105-1
20050105-2
20050106-1
...etc.
This would be a great place for a stored procedure, but I don't know
if I can recommend running MySQL 5 to you. The most platform-safe way
an open source alternative that does offer this enterprise level
functionality (stored proced
> -Original Message-
> From: Andrew Kreps [mailto:[EMAIL PROTECTED]
> Sent: Thursday, January 06, 2005 12:30 PM
> Subject: Re: [PHP-DB] MySQL Auto PK
>
> On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
<[EMAIL PROTECTED]> wrote:
> > OOzy Pal wrote:
> &g
On Friday 07 January 2005 02:29, Andrew Kreps wrote:
> This would be a great place for a stored procedure, but I don't know
> if I can recommend running MySQL 5 to you. The most platform-safe way
> I can think of is to get a count(*) of the number of rows with today's
> date, add 1 to it, and sti
On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
<[EMAIL PROTECTED]> wrote:
> OOzy Pal wrote:
> > Is it possible to have mysql at an ID as 20050105-1 as
> > (MMDD-1), -2, etc.
>
> automatically? No. But you can always just use
>
> SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ...
>
> i
OOzy Pal wrote:
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
automatically? No. But you can always just use
SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ...
if you _really_ need something like this. Or just join them together in
PHP.
--
---John Holmes...
A
OOzy Pal wrote:
Dears,
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
probably, possibly, maybe. take your pick.
as Martin Norland already pointed out to someone else; this is not
[EMAIL PROTECTED] (that beauty of a comment is forever burned
into my neo-cortex! :-)
Dears,
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
OOzy
=
Regards,
OOzy
What is the purpose of life?
__
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mai