Mysql modify foreign key

-- 2 Step process
ALTER TABLE tbl_name_1 DROP FOREIGN KEY fk_name;
ALTER TABLE tbl_name_1 ADD FOREIGN KEY fk_name(fk_col)
            REFERENCES tbl_name_2(pk_name) ON DELETE RESTRICT;


-- Use to find the name of the FOREIGN KEY 
SHOW CREATE TABLE tbl_name;

Source: stackoverflow.com

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);

Source: es.stackoverflow.com

Update foreign key value in mysql

SET foreign_key_checks = 0;
UPDATE languages SET id='xyz' WHERE id='abc';
UPDATE categories_languages SET language_id='xyz' WHERE language_id='abc';
SET foreign_key_checks = 1;

Source: stackoverflow.com

Similar codes

1 vote183 views1 answer
Sql server select rows by distinct column
SQL
0 vote278 views1 answer
Postgresql powershell query
SQL
0 vote230 views1 answer
Mysql relationships between tables
SQL
0 vote196 views2 answers
How to know the character set of an oracle databes
SQL
0 vote214 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
8 votes200 views2 answers
Between operator
SQL
4 votes212 views1 answer
For loop postgresql
SQL
0 vote153 views2 answers
Sql query unique
SQL
0 vote211 views1 answer
Postgresql linux password
SQL
2 votes202 views1 answer
Oracle index size
SQL