Is there a way with MySQL (5.0 specifically) to have an auto_increment field who's value is based on a grouping column?
Example:
id name group_field
1 test 1
2 test2 1
1 test3 2
2 test4 2
1 test5 3
2 test6 3
I'd like to not have to go through any 'crazy' methods to achive this, but will if necessary.