I want to create a table called Label with the following columns:
Label_ID (Auto Increment Primary Key), LabelName, LabelValue
I want to Create another table called Feat with the following Columns:
Feat_ID(Auto Increment Primary Key), Feat_Label_ID(Foreign key, it is just the Label_ID from previous table), FeatName,FeatValue
I want to know how I can create auto increment random ID's primary keys for each of my tables like 54DA90C0 and also How can I make an auto incremental primary key of one table as foreign key of another table.
Thanks in advance.