Drop foreign key mysql

Foreign key mySql

CREATE TABLE parent (
    id INT NOT NULL,
    PRIMARY KEY (id)
) ENGINE=INNODB;

CREATE TABLE child (
    id INT,
    parent_id INT,
    INDEX par_ind (parent_id),
    FOREIGN KEY (parent_id)
        REFERENCES parent(id)
        ON DELETE CASCADE
) ENGINE=INNODB;

Source: dev.mysql.com

Drop all foreign key constraints mysql

SET foreign_key_checks = 0;

Source: stackoverflow.com

Mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name

Mysql drop key

ALTER TABLE tbl_quiz_attempt_master
  DROP INDEX `PRIMARY`;

Source: stackoverflow.com

Drop foreign key mysql

ALTER TABLE table_name DROP FOREIGN KEY constraint_name

Source: tutorialspoint.com

Add column mysql with foreign key

ALTER TABLE `TABLE_NAME`
ADD COLUMN `COLUMN_NAME` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `AFTER_COLUMN_NAME`, 
ADD FOREIGN KEY `FOREIGN_RELATION_NAME`(`COLUMN_NAME`) REFERENCES `FOREIGN_TABLE`(`FOREIGN_COLUMN`)  ON UPDATE SET NULL ON DELETE SET NULL

Similar codes

0 vote190 views1 answer
QUERY JPQL
SQL
0 vote168 views1 answer
How to check replication lag in mySQL
SQL
0 vote198 views1 answer
SQL Hello, [firstname] [lastname]
SQL
7 votes178 views1 answer
Xampp reset mysql
SQL
0 vote153 views1 answer
Como leer datos de mysql esp32
SQL
1 vote188 views1 answer
Store select query result in variable sql server
SQL
0 vote179 views1 answer
Like date sql server not working
SQL
12 votes198 views1 answer
Run mysql instance in docker
SQL
15 votes166 views3 answers
Create table with primary key auto increment in sql
SQL
1 vote156 views1 answer
How to open closed port mysql in ubuntu
SQL