Autocolumn and pk

[Linus Nikander]

I'm pretty new to mySQL so there might be an easy way of solving this
(hopefully)

Is there a way to create something akin to an Oracle Sequence in mySQL ?

I know of the autonumber feature. The problem is that the table that will be
using the key won't actually be using it as a unique pk. The pk will instead
consist of the autonumber + the value of another column. Thus, using
autonumber on a column of the target table isn't really an option.

I can think of one way of solving it. I could create a table with a single
autonumber column for the sole purpose of generating the numbers (when i
need them). That is going to clutter up my tables in the long run though,
and isn't really something I want to do. Is that the only viable solution,
or is there some functionality that I don't know of which does it better ?

//Linus Nikander - linus@stripped