I'm adding a new item to my table, but they got wrong ID's! First I write the ID's manually but then I change to Auto Increment and delete all items of the table. Now the ID's starts , where my last were. How can I changed it to 1? Thank you!
Asked
Active
Viewed 91 times
0
Hitesh
- 3,449
- 8
- 39
- 57
user3338614
- 1
- 3
-
1Which database are you using? – DaveH Mar 01 '14 at 12:21
-
Just truncate your table and then add records if you are using sql server. – angfreak Mar 01 '14 at 12:22
-
Hi thank you for answers. I'm using MySQL. – user3338614 Mar 01 '14 at 12:25
-
This works, but the table has to be empty. – Ulrich Thomas Gabor Mar 01 '14 at 12:56
-
just run this query in mysql: `TRUNCATE TABLE table_name;` and you're good to go. – CodeBird Mar 01 '14 at 13:05