Monday 15 April 2013

mysql - Use AUTO_INCREMENT two insert two different IDs into one table -


I wanted to add a second AUTO_INCREMENT field to my database in phpMyAdmin.

But I get an error:

wrong table definition; There may be only one auto column and it must be defined as a key

This means that I only have one auto_increment field allowed.

My problem is now, I have a shop and I want to include order_person_id and order_id in my table order I am How can I do this without auto_increment ?


No comments:

Post a Comment