create table table2 (
uid int NOT NULL,
table1_uid int NOT NULL,
primary ket(uid).
constranint name foreign key(table1_uid) references table1(uid),
)type=InnoDB;
uid int NOT NULL,
table1_uid int NOT NULL,
primary ket(uid).
constranint name foreign key(table1_uid) references table1(uid),
)type=InnoDB;
看手册上的语法。
alter table table2 add index index_table2_table1_uid(table1_uid);
用describe查看表结构时,该字段key显示的是MUL