HOW TO DEFINE PRIMARY KEY IN MULTIPLE COLUMNS IN MYSQL code example

Example: mysql multiple primary keys

CREATE TABLE userdata (
  userid INT,
  userdataid INT,
  info char(200),
  primary key (userid, userdataid)
);