Answers for "create a table that uses a primary key which is foreign key to other table in mysql"

create table mysql with foreign key

CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);

Posted by: Guest on November-03-2020

Code answers related to "create a table that uses a primary key which is foreign key to other table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "create a table that uses a primary key which is foreign key to other table in mysql"

Code answers related to "create a table that uses a primary key which is foreign key to other table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "create a table that uses a primary key which is foreign key to other table in mysql"

Code answers related to "create a table that uses a primary key which is foreign key to other table in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us