mariadb add foreign key
alter table group_a
add constraint fk_b_in_a
foreign key(`b_id`)
references group_b(`b_id`)
on delete set null
on update set null;mariadb add foreign key
alter table group_a
add constraint fk_b_in_a
foreign key(`b_id`)
references group_b(`b_id`)
on delete set null
on update set null;create table in mysql mariadb primary key foreign key
CREATE TABLE IF NOT EXISTS `scores` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
UserId int(11) NOT NULL,
`NICKNAME` varchar(50) NOT NULL,
`HIGHSCORE` int(11) NOT NULL,
PRIMARY KEY (`ID`),
FOREIGN KEY (UserId) REFERENCES USER(Id)
);alter table add foreign key mariadb example
alter table caixa add foreign key (idcaixafluxo) references caixafluxo (idcaixafluxo);Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
