Тёмный

Primary Key and Foreign Key in MySQL Explained with Examples | MySQL Tutorial 

Подписаться
Просмотров 79 тыс.
% 1 336

In this video, learn Primary Key and Foreign Key in MySQL Explained with Examples | MySQL Tutorial. Find all the videos of the MySQL Full Course in this playlist: ru-vid.com/group/PLjVLYmrlmjGeyCPgdHL2vWmEGKxcpsC0E
💎 Get Access to Premium Videos and Live Streams: ru-vid.com/show-UC0T6MVd3wQDB5ICAe45OxaQjoin
WsCube Tech is a leading Web, Mobile App & Digital Marketing company, and institute in India.
We help businesses of all sizes to build their online presence, grow their business, and reach new heights.
👉For Digital Marketing services (Brand Building, SEO, SMO, PPC, SEM, Content Writing), Web Development and App Development solutions, visit our website: www.wscubetech.com/
👉Want to learn new skills and improve existing ones with in-depth and practical sessions? Enroll in our advanced online courses now and make yourself job-ready: courses.wscubetech.com/s/store
All the courses are job-oriented, up-to-date with the latest algorithms and modules, fully practical, and provide you hands-on projects.
👉 Want to learn and acquire skills in English? Visit WsCube Tech English channel: bit.ly/2M3oYOs
📞 For more info about the courses, call us: +91-7878985501, +91-9269698122
✅ CONNECT WITH THE FOUNDER (Mr. Kushagra Bhatia) -
👉 Instagram - kushagrabhatiaofficial
👉 LinkedIn - www.linkedin.com/in/kushagra-bhatia
Connect with WsCube Tech on social media for the latest offers, promos, job vacancies, and much more:
► Subscribe: bit.ly/wscubechannel
► Facebook: wscubetech.india
► Twitter: wscubetechindia
► Instagram: wscubetechindia
► LinkedIn : www.linkedin.com/company/wscubetechindia/
► RU-vid: ru-vid.com
► Website: wscubetech.com
--------------------------------------| Thanks |---------------------------
#MySQLTutorial #MySQLCourse #MySQL

Опубликовано:

 

19 фев 2022

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 45   
@gauravpathak4479
@gauravpathak4479 9 месяцев назад
01:27 Primary key and foreign key constraints in relational databases 02:54 Creating a primary key in a database for unique identification 04:21 Foreign key creates linking between two tables 05:48 Foreign keys link the primary keys of two tables, enabling joint operations. 07:15 Creating a students table with primary and foreign keys 08:42 Creating a city table with id as primary key and city_id as foreign key 10:09 City ID 522 is located in city ID 609 11:29 Enforcing primary key and foreign key constraints is crucial in large-scale relational databases.
@strangerealm796
@strangerealm796 Год назад
Sir table banai hai lekin bol rha hai referencing column city_id and referenced column cities (id)is incompatible.😢
@rksvlog2529
@rksvlog2529 Год назад
Great....amazing technique
@vinaymishra8533
@vinaymishra8533 2 года назад
sir great work I had search more then 10 tutorials to find this concept but now it is clear
@MuhammadAyaz_786
@MuhammadAyaz_786 Год назад
what a great work sir
@user-xo5yv9uj8v
@user-xo5yv9uj8v Год назад
Good explanation
@vedsharma1933
@vedsharma1933 Год назад
thanks
@theAdam586
@theAdam586 5 месяцев назад
5. What is a foreign key? Write a query to implement the same in MySQL. This is one of the prevalent MySQL queries interview questions for both beginner and experienced candidates. A foreign key is used to connect two tables. A FOREIGN KEY is a field (or assortment of it) in one table that alludes to the PRIMARY KEY in another table. The FOREIGN KEY requirement is utilised to forestall activities that would crush joins between tables. To assign a foreign key, it is important to mention it while creating the table. It can be assigned by invoking the FOREIGN KEY query. Something like this: FOREIGN KEY (Any_ID) REFERENCES Table_to_reference(Any_ID)
@Akagarkar2024
@Akagarkar2024 2 года назад
kodular ya thunkable per ek video upload kijiye sir please
@manyadewangan6765
@manyadewangan6765 Год назад
I have a good doubt sir if we use primary key while creating columns then unique constraint ka koi use nhi hoga?
@Bhumi_rai
@Bhumi_rai Год назад
unique key mysql accept hi nhi karaga because 1 column pa 2 constraint nhi hote
@hamzaarif6000
@hamzaarif6000 11 месяцев назад
Jab ap kisi column ko primary key set krtay ho to unique constraint lganay ka faida hi nahi q k primary key k column ki hr value unique e hoti hai. Primary key or Unique constraint mein difference ye hai k Primary key hum table k kisi aik column pr lga sktay hain jabkay unique constraint hum table k multiple columns pr lga sktay hain
@hamzaarif6000
@hamzaarif6000 11 месяцев назад
​@@Bhumi_rai2 constraint ho sktay hain. Mainy try kiya tha or mere accept hogaye thy
@nikhilmore3771
@nikhilmore3771 11 месяцев назад
PRIMARY KEY is parent (confirm on other sources)
@RajeshKumar-jx9ql
@RajeshKumar-jx9ql Год назад
city_id kisi or table ki primary key hone wali h.....esa kyu hoga???? jbki kisi or table me to already primary ki hmne de rakhi h
@coolanujkumar5
@coolanujkumar5 Год назад
missing index for constraint .... in the referenced table
@divyanshsingh8807
@divyanshsingh8807 Год назад
Solution h kya kuch
@bhaveshmorankar8579
@bhaveshmorankar8579 11 месяцев назад
failed to add the foreign key dikha raha hai isko kaise solve kre?
@strangerealm796
@strangerealm796 Год назад
Jinka error aa rha ho vo cities ki table me primary key (Id) rakhe phrr chal jayega.
@puneetsharma8091
@puneetsharma8091 6 месяцев назад
Thanks
@Ukmmtj1
@Ukmmtj1 7 месяцев назад
2:06 email bhi unique hi hota h🤔
@technicalrider6196
@technicalrider6196 10 месяцев назад
Wrong teaching u have add primary key to city_id if ur refering city_id primary key to foreign key (cid)
@prasantaroutray2506
@prasantaroutray2506 8 месяцев назад
bro are you from odisha?
@vinaymishra8533
@vinaymishra8533 2 года назад
sir pura syllabous nahi hua hai abhi
@Roller_Roaster
@Roller_Roaster Год назад
id mai 3 kyu show kr raha last mai?
@vishnujatav6329
@vishnujatav6329 2 года назад
important
@shubhamnimbalkar8659
@shubhamnimbalkar8659 Год назад
yedee chale mat kar aaise .....important portion tu bad mai sikha raha hai student ko ...primary key foreign key pahile sikhana tha....time wast
@lion7366
@lion7366 Год назад
Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint
@khushiv2003
@khushiv2003 Год назад
Same problem
@ruturajkadam5164
@ruturajkadam5164 Год назад
​@@khushiv2003add constraint while adding foreign, you can give it any namr
@ayushpratap8301
@ayushpratap8301 11 месяцев назад
In the 1st table that is "cities", at last write primary key (cid)
@shak1maangaming849
@shak1maangaming849 Год назад
failed to add misssing constraints error aa rha hai sir g??
@Tadapatiatma
@Tadapatiatma Год назад
Mila answe nhi mila to main bata sakta hun
@divyanshsingh8807
@divyanshsingh8807 Год назад
Koi batayega iska solution kya h
@pulkitjadoun8596
@pulkitjadoun8596 Год назад
@@Tadapatiatma bata de bhai kese theek hoga
@Tadapatiatma
@Tadapatiatma Год назад
​@@pulkitjadoun8596 pehle apko 1st table Banna hai jismein apko primary key rakhna hai jo apka 2nd table ka foreign key hoaga means apko pehle 1st table ka primary key create karna ho ga tabhi to ap usko 2nd table mein foreign key aur reference de payenge
@pulkitjadoun8596
@pulkitjadoun8596 Год назад
@@Tadapatiatma ok bro thanks
@_.innovative_pixel
@_.innovative_pixel 3 месяца назад
8:00
@shelkeonka
@shelkeonka Год назад
Sir 3 br try Kara laekin failed to add missing constraints error araha hai
@Tadapatiatma
@Tadapatiatma Год назад
Mila answer nhi mila to main bata sakta hun
@gopalbarnwal7459
@gopalbarnwal7459 Год назад
@@Tadapatiatma bolo
@rahuldatta1382
@rahuldatta1382 Год назад
@@gopalbarnwal7459 in the settings of cities, you have to select cid as a primary key
@pulkitjadoun8596
@pulkitjadoun8596 Год назад
@@rahuldatta1382 kar liys fir bhi nahi ho raha
@harshadaborade5712
@harshadaborade5712 2 месяца назад
Worst explanation
@samiahirfanghouri1136
@samiahirfanghouri1136 3 месяца назад
Good explanation