120. Composite Key in SQL (Hindi)

Please Subscribe Channel
Like, Share and Comment

[Abdulllah-]

bro keep it up, best video <3
pata nahi kon jahil loog hain jinhoon ne dislike kia hai
give me one single reason for disliking this video

[HemantSharma-vnew]

which mic you used to create video plz tell me. voice is very clear.

[SushmitaDas-ee]

is it widely used in real life ? plz respond asap.

[PSRRSRPSR]

is it posible to more then one primary key in table (if no then y you are using two primary key in composit)

[khanlover]

sir almost after 6 years I'm watching your lectures
is it possible may happend minor changes into syntax or anything else in sql

[nitinkharje]

code aur date lekar banai hui key be same ho sakati same course code and and same date

[akhilkumarsingh]

ye lo bahi.. insert kar lena
-- CREATE TABLE course(
-- Coursecode varchar(40),
-- Date date,
-- Cname varchar (40),
-- Room int,
-- PRIMARY KEY (Coursecode, date)
-- );
INSERT INTO course
VALUES('KCS01', '2020-07-19', 'C', 20),
('KCS01', '2020-08-19', 'C', 19);

select * from course
where Coursecode='KCS01' and date='2020-07-19'

[sivachelapaka]

It is assigning primary key for the combination of primary keys from different tables.

[mohanbhaibechardaschauhan]

dbms kai rite open prectical ma krvnu?

[shubhammural]

how we can fetch the data based on composite key ?

[samarchinnagouni]

In before tutorials u said that there will be only one primary key ..In this tutorial you are assining two columns as primary keys ..How it is possible pls explain

[saurabhmaurya]

ham composite key ko as a foreign key Kaise use karenge? koi batao...

[SanjayVerma-pmyw]

Ekdum tonny kakkar k gaane ki trh repeat kiye ho aap🤣

[aamirali]

how we can describe a composite key and functional dependency X->Y using this example.

[vittalpatil]

In one table only one primary key allowed so how here 2 PK's ?? Pls explain anyone

[shivaniwakde]

we can add only one primary key in table so how can we make 2 primary keys in this table?

[anmolyadav]

itna ganda koin kaise sAMJHA SAKTA HAI


ek line ko kitni baar bole ga

[varshilpatel]

What bro, for the first half you are repeating the same thing. It just spoiled my mood. We know now that it 'uniquely identifies'.