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

2 votes243 views5 answers
Alter table primary key postgresql
SQL
3 votes242 views3 answers
Mysql select table names
SQL
0 vote247 views1 answer
Many rows to 1 string mysql
SQL
0 vote266 views2 answers
Sql query inner join 3 tables
SQL
-1 vote260 views5 answers
Online sql to linq generator
SQL
1 vote252 views1 answer
Sql trigger before delete
SQL
13 votes259 views3 answers
Sql select from multiple tables without join
SQL
1 vote251 views2 answers
Rebuild index sql server
SQL
21 votes259 views5 answers
Oracle all tables
SQL
0 vote253 views1 answer
Database timezone
SQL