Answers for "update constraint mysql"

SQL
1

mysql alter add foreign key

ALTER TABLE ordenes ADD ticket VARCHAR(50) NOT NULL;
ALTER TABLE ordenes ADD CONSTRAINT fk_ticket FOREIGN KEY (ticket) REFERENCES tickets(ticket);
Posted by: Guest on October-19-2020
0

foreign key type uniqu mysql

mysql > create unique index index_bar_id on foos(bar_id);
mysql > alter table foos add constraint index_bar_id foreign key (bar_id) references bars (id);
Posted by: Guest on October-16-2020

Code answers related to "update constraint mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language