Tuesday, April 8, 2014

simple way to Create two primary key in one table(composite key)


simple way to Create two primary key in one table(composite key)

but auto increment only one coulmn to assign.
code:-
ALTER TABLE provider DROP PRIMARY KEY, ADD  PRIMARY KEY(person, place, thing);

No comments: