Hi
I am fairly new to MySql. I have created a table and after a few entries I made the ID into AI. This works OK but a couple of questions;
1. Because I started without AI then did it started the increment at 5. is there away to start it at a number you want it to like 1.
2. Is there a way, for example, when we add anew quote in the quote table we can put a Q in front of the number and start at 100 for example, so the first quote would be Q100.
3. After all testing is there a way to set all the numbers back to start at 1 or 100 in the relevant table.
Thanks
I am fairly new to MySql. I have created a table and after a few entries I made the ID into AI. This works OK but a couple of questions;
1. Because I started without AI then did it started the increment at 5. is there away to start it at a number you want it to like 1.
2. Is there a way, for example, when we add anew quote in the quote table we can put a Q in front of the number and start at 100 for example, so the first quote would be Q100.
3. After all testing is there a way to set all the numbers back to start at 1 or 100 in the relevant table.
Thanks