When I try to input new values I get this:

SQL error:

Query:
insert into Tee_Details (Tee_ID, Tee_Name, Hole, Yards, Par, Hole_HDCP) values ('00001', '0000001', '2', '446', '4', '8')

Duplicate entry '00000' for key 1

I know it has to do with the first two values but is there a way I can keep both values and not get the error message. Sorry Newbie!

It could be that you have a field that's set to auto_increment this will make the number 1, 2, 3, etc etc. OR it could be a field that's set to unique, just remove it from being unique. Without understanding your table structure and how you expect it to work it is difficult to diagnose.

Is there any way to make auto increment (I have two fields in my db on AI) start at a number like one starts at 100001 and another starts at 20001 so they don't duplicate? Thanks.

mysql> ALTER TABLE tbl AUTO_INCREMENT = 1000;

it could be a field that's set to unique, just remove it from being unique Is there any way to make auto increment (I have two fields in my db on AI) start at a number like one starts at 100001 and another starts at 20001 so they don't duplicate?