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

3 votes296 views2 answers
Oracle sql first day of month
SQL
14 votes276 views3 answers
Delete all records from table except sql
SQL
16 votes274 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
10 votes265 views4 answers
Inner join in update query mysql
SQL
1 vote293 views3 answers
How to reset id column in sql server
SQL
0 vote259 views1 answer
Sql query interview questions githu
SQL
3 votes259 views2 answers
Oracle apex charging debug
SQL
0 vote275 views1 answer
Sql developer search all packages for text
SQL
5 votes261 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
1 vote256 views1 answer
Oracle create program if no exists
SQL