I have a complex primary key, I wonder if what I write in the title is possible:
I have a look up table with 4 fields (they should compose the primary key of the table):
1) an INT column;
2) Another INT column;
3) A YEAR column;
4) another INT column which should be AUTO_INCREMENT.
The 1) and 2) fields are also FOREIGN KEYS of another table, and I need them to be so.
How can I handle this?