[English_Fire]

EDIT: I have solved the original problem, I had a logical error that I didn't notice.

NEW QUESTION:

How can I reset the auto increment on my primary key?

If I have 10 records, and delete them all, and then enter a new record, the id will be 11.... how can I make this AI index reset without deleting everything?

[Disease]

EDIT: I have solved the original problem, I had a logical error that I didn't notice.

NEW QUESTION:

How can I reset the auto increment on my primary key?

If I have 10 records, and delete them all, and then enter a new record, the id will be 11.... how can I make this AI index reset without deleting everything?

You can alter the auto_increment value by the following:

Code

ALTER TABLE table_name AUTO_INCREMENT = new_value

[Novalty]

EDIT: I have solved the original problem, I had a logical error that I didn't notice.

NEW QUESTION:

How can I reset the auto increment on my primary key?

If I have 10 records, and delete them all, and then enter a new record, the id will be 11.... how can I make this AI index reset without deleting everything?

Truncate your MySQL table. It should reset the auto incrementing fields!

[English_Fire]

You can alter the auto_increment value by the following:

Code

ALTER TABLE table_name AUTO_INCREMENT = new_value

Okay, cool. So what would I put for the value...just 1? and then every after would follow accordingly?

Truncate your MySQL table. It should reset the auto incrementing fields!

I shall look this up, thanks.