Re: Reference question and auto increment

2001-04-19 Thread Gerald Clark
Why would you want to re-use the deleted ID? That would be a poor design. When you insert a new record with an autoinvcrement, last_insert_id() will tell you what it is so you can insert it in dependent tables. Fates wrote: > > I am trying to understand references in tables and using primary ke

Reference question and auto increment

2001-04-19 Thread Fates
I am trying to understand references in tables and using primary keys with auto increment option as a reference to all tables: What is the best way to reference other tables? I have three tables: menus, categories, and links. I also have an ID field in each table that uses the autoincrement opt