database design help (mysql)

i need to set up a rather complicated system using mysql. my idea is sound, but the implementation is quite tricky.. i was wondering if anybody knew some kind of trick or knows how to deal with a problem like this..

i plan on using two indexes to organize the data. both will be set to AUTO_INCREMENT, except that one has to depend on the other. that might sound a bit confusing.. so heres a little example:

COL1 COL2
1 1
1 2
1 3
2 1
2 2
3 1
3 2

in general, each item in COL1 has a unique value in COL2, and both are set to auto_increment. i can't figure out a way to implement this, though.

if you still have no idea what i'm saying, reply to this and i'll get into the specifics.

please help. thanks! database design help (mysql)

 

 

 

 

Top