Answers for "how to create foreign key in mysql using structure 2020"

SQL
7

create foreign key phpmyadmin

ALTER TABLE table_name
ADD CONSTRAINT fk_foreign_key_name
FOREIGN KEY (foreign_key_name)
REFERENCES target_table(target_key_name);
Posted by: Guest on June-11-2020
11

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;
Posted by: Guest on March-02-2020

Code answers related to "how to create foreign key in mysql using structure 2020"

Code answers related to "SQL"

Browse Popular Code Answers by Language