Hi,
I was testing my database, and had entered in about 10 test entries. Well, I wanted to start over, so I deleted everything like this: DELETE FROM table WHERE id > 0...so this deleted everything...the table was empty. But when I started inserting new data, the auto-increment for the primary key started off where the last one ended...why would it do this if I deleted everything?
So instead of starting back at 1, or started at 11.
Thanks
I was testing my database, and had entered in about 10 test entries. Well, I wanted to start over, so I deleted everything like this: DELETE FROM table WHERE id > 0...so this deleted everything...the table was empty. But when I started inserting new data, the auto-increment for the primary key started off where the last one ended...why would it do this if I deleted everything?
So instead of starting back at 1, or started at 11.
Thanks