Actually, I thought of one possible solution for that: move all the
records to another (temp) table, truncate the table, and add the pre-
existing records back.  That would reset the ID.

GreyCells wrote:
> I think you mean compund primary key. See:
>
> http://groups.google.com/group/cake-php/browse_thread/thread/4a3f44f8217435cc/255c641339eef6ac?lnk=gst&q=compound+primary+key&rnum=1#255c641339eef6ac
>
> Especially Nate's comments. Coincidentally, I had a requirement for
> one today - but only because mysql can't recycle sequences...
>
> ~GreyCells
>
> On Apr 18, 6:14 pm, "John David Anderson (_psychic_)"
> <[EMAIL PROTECTED]> wrote:
> > On Apr 18, 2007, at 10:08 AM, christianandradet wrote:
> >
> > > I don't know what to do, how do i define the composed primary key???
> >
> > Why do you need one? Is 'id' not unique?
> >
> > -- John


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to