mysql - I want to add foreign key to my second table (sports) for column AdmNo -

mysql - I want to add foreign key to my second table (sports) for column AdmNo -

mysql> desc students;

+---------+-------------+------+-----+---------+-------+ | field | type | null | key | default | | +---------+-------------+------+-----+---------+-------+ | admno | int(5) | no | pri | null | | | name | varchar(40) | yes | | null | | | class | int(2) | yes | | null | | | sec | char(1) | yes | | null | | | rno | int(2) | yes | | null | | | address | varchar(35) | yes | | null | | | phone | int(9) | yes | | null | | +---------+-------------+------+-----+---------+-------+ 7 rows in set (0.02 sec)

mysql> desc sports;

+-----------+-------------+------+-----+---------+-------+ | field | type | null | key | default | | +-----------+-------------+------+-----+---------+-------+ | admno | int(5) | yes | | null | | | game | varchar(35) | yes | | null | | | coachname | varchar(30) | yes | | null | | | grade | char(1) | yes | | null | | +-----------+-------------+------+-----+---------+-------+ 4 rows in set (0.02 sec)

i want add together foreign key sec table (sports) column admno.

try this:

alter table sports add together foreign key (admno) references students(admno)

mysql