SQL to create fk int in TABLE

Question

1. Film
2. COD (int, pk)
3. name(varchar 20, not null)
4. birth (datetime, not null)
5. Obs(tinybit, not null)
6. Obs2(int, fk, not null)

I thought of something like

create table filme (
COD int PRIMARY KEY AUTO_INCREMENT,
nome varchar(200) NOT NULL,
nascimento datetime NOT NULL,
obs tinyint NOT NULL,
obs2 int NOT NULL

)

I can’t create fk...

how do I create a fk int?

Answer 1

you can do so:

create table filme (
COD int NOT NULL AUTO_INCREMENT,
nome varchar(200) NOT NULL,
nascimento datetime NOT NULL,
obs tinyint NOT NULL,
obs2 int NOT NULL
PRIMARY KEY (COD),
FOREIGN KEY (obs2) REFERENCES OutraTabela(ColunaChave)
);

if you have already created the table can add a foreign FK key like this:

ALTER TABLE `filme ` ADD CONSTRAINT `fk_filme` FOREIGN KEY ( `obs2` ) REFERENCES `OutraTabela` ( `ColunaChave` ) ;