Mysql DATABASE

[zigi 01]

nawezaje kutengeneza more than one table na kuzi link ? yaani kuifanya relational database?

 

[MdengestanfromCuba]

Tumia kitu inaitwa 'foreign key'

 

[zigi 01]

Tumia kitu inaitwa 'foreign key'

kivipi nielekeze kidogo mkuu! I'm beginner

 

[MdengestanfromCuba]

Foreign key ndiyo inayoleta relationship kati ya table, ambapo primary key ya table ya kwanza inakua referenced katika table ya pili kupitia hiyo foreign key, na Kuna aina nyingi za relationship (one to one, one to many, many to many etc) ambapo hata utengenezaji wa it foreign key unategemea aina ya relationship unayoitaka.....ila endelea kujifunza tutorial zipo online

 

[thesym]

Foreign key ndiyo inayoleta relationship kati ya table, ambapo primary key ya table ya kwanza inakua referenced katika table ya pili kupitia hiyo foreign key, na Kuna aina nyingi za relationship (one to one, one to many, many to many etc) ambapo hata utengenezaji wa it foreign key unategemea aina ya relationship unayoitaka.....ila endelea kujifunza tutorial zipo online

Constraints za foreign na primary key zinatumika kama

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

Ref: SQL FOREIGN KEY Constraint

 

[Extrovert]

Hii kitu inachanganya sana akili

 

[MdengestanfromCuba]

Constraints za foreign na primary key zinatumika kama

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

Ref: SQL FOREIGN KEY Constraint

Yes mkuu umeeleza vyema sana