Is it possible to have a composite key in mysql(5.1) and if so, what is the syntax?
references table b
With InnoDB tables, you can, like:
create table YourTable ( col1 int, col2 int, constraint foreign key (col1, col2) references OtherTable (col1, col2) on delete cascade ) type=InnoDB;
MyISAM tables, foreign key constraint are silently ignored.