MySQL PRIMARY KEY & FOREIGN KEY Tutorial in Hindi / Urdu
Вставка
- Опубліковано 22 лис 2019
- In this tutorial you will learn mysql primary key and foreign key tutorial in Hindi, Urdu.You can learn how to use mysql contraints primary key and foreign key on tables columns.You will also know what is difference between primary key and foreign key in hindi.
PHP Tutorial in Hindi Playlist
• ✅ PHP Tutorial in Hind...
MySQL Tutorial in Hindi / Urdu Playlist
• 🥇 MySQL Tutorial for B...
Official Website
www.yahoobaba.net/
Follow us on Facebook
/ yahooobaba
Follow us on Twitter
/ yahooobaba
#mysql #webdevelopment #php
You are remarkably talented in how to teach step by step.
Proper visualization.
I'll say perfect.
perfect explanation, im a non IT guy but understand it very easily ...worth to watch this series.
Good 👍
One of the best YT channel to learn programming
Easiest way to learn _primary-foreign_ key. Thanks sir👍
I will never forget this explanation
Your teaching skills are soooooooooooooooo goooooood sir
Thank you 🙏
Never seen such a excellent explanation.........
Thanks for appreciating my work :)
Yes u are absolutely Right !!
I know it is quite randomly asking but do anyone know of a good website to watch new series online ?
@@guscolt2057 alt Balaji
Acchha samajh Gaya bhai ko bahot shi
Thanks for the great videos as the content is very understandable, accurate and concise way
quick to brash up the concepts
Glad you like them!
brilliant teaching sir.....💕
You came as blessing sir.... Thanku so much sir❤
Great time I am having with this course to so much sir
Bhut vadia treke nl clear kita sir g thanks 👍🙏
Excellent way of teaching..
Your explanation is osm... Tysm🥰
lovely explanation...to the point video... respect ++
Glad you liked it
perfect example sir....... thankyou sirr...
The whole tutorial video playlist is the savior for me . Thank you so much for such detail explanation
Glad it was helpful!
I watched many videos, but was not clear, but you have explained it very well just like my ORACLE Teacher when i was in Collage, Thanks
Glad it was helpful!
Nice explanation by yahoo baba full return of time.
In college teacher takes fees and waste more time of students.
You are great yahoo baba❤❤
Thanks a lot
no one can teach better than this.. 🧡
Thanks for appreciating my work :)
very good explanation 🎊🥰
GREAT sir ji👏🏻👏🏻🙏🏻😁
i am following your whole tutorial playlist for sql . it is really nice
Thanks :)
Very well explained mysql Primary Key and Foreign key
Thanks :)
There can be set of columns that can be primary key also 👍
zaberdast sir mind blowing super bhot acha samjhaya hai ap nay
Thanks :)
Awesome sir 👍😎
Bohot hi mahol padhate ho sir ji aap.. 1st time apki video dekhi.. n I m ur fan... Bohot easy Way se sikhate ho..
Thanks for appreciating my work :)
nice video thankyou
Hello sir store procedure pr video laye aap bahut achchhe se padhate hai
yar aapki voice my god kitni mst h jaise delhi metro me bolte h
Your pitch of voice is very pleasant to hear. Explained Perfectly for beginners.
Thanks for appreciating my work :)
Dono tables create krke img send kro kar do sir plzz glt ho raha hai
sir you are such a greate techer
itna aacha syd hi koi pada apaya
Thanks for appreciating my work :)
Sir jaldi upload kro...please make as soon as possible
Thanks a lot
Helpful ❤️
Great brother nice job
Thank you so much 😀
THANKS SIR FOR THIS VIDEO IT REALLY WORK
Your most Welcome :)
your teaching skill are best
Thanks a lot
It's A very Good explanation for me ... ❣️ And i Can't stop my fingers to Subscribe You ❣️❣️❣️
Thanks and welcome :)
thank you for this useful videos
You are welcome
Sir I am b.com final year student ... And now my computer professor is teaching us SQL but it's a old version by looking at your videos syntax are different... Please help me with old version sir.
Excellent explanation sir
Thanks for liking
thanks_Sir💜
Sir g ERP SAFTWERE BNANE ME PHP KE SATH - SATH OR KON SA COURSE KI NEED HAI
Very nice sir
Thanks a lot sir😇😇😇🙂🙂🙂🙃🙃🙃🙃😊😊😊😊😋😋😋😋
Most welcome
at 6:15 the name of column City in Student Table should be Cid which is primary key in City Table and foreign key in Student Table. Name must remain same should not changed.
sir ajkl jo companies websites bna ri hai. all devices perfect hoti hai. but bootstrap se nahi hoti ya custom media quries se kro toh bhi kami reh jati hai toh pls yeh zroor bnaiye alag se video. your all videos are nice. thanx this hardwork for us.
Yes sure main jald hi es topic par video banaunga.
good job
Excellent
bhut achha bhut khoob
Thanks and welcome :)
thank you sir...
Most welcome
Finished watching
Great
if you Add Lecture Number in video title it will be more helpful and easy to search. thankyou
I already placed Video Number in the Lower Left Corner of video thumbnail.
Sir I am getting this error
Error code:3780. Reference column 'city' and referenced column 'cid' in foreign key constraint ' personal_ibfk' incompatible.
Please reply
The insert statement conflicated with the foreign key the conflict occured in database table column
Thanks for
Thank you sir
Welcome
thanks for every single video❤️❤️❤️🧗♂️
Your welcome :)
Make one more video on primary and foreign key
Good
Nice explain
Thanks and welcome
Please make a video on powerbi
Please make a project using php mysql javascript & ajax.
MySQL course ke bad project Shuru Hone wala PHP with MySQL
@@YahooBaba OK
MySQL optimization ka video bhi bna lijiye sir
Sure
I think these people are more intelligent than me
Dear sir please make a video that how to use xamp server after created a web site by html css javascrip .
Coming Soon :)
Make video on postgresql
Iske baad ak normal ER diagram iske upr bana k relation samaja k video banna chahiye tha
Sir personal table me insert row me last ka 1 liya he wo kiske base me liya he . Please reply.
Can you please share the whole presentation file, it will be helpful for your students. Thank you!
You can get it from our website : www.yahoobaba.net
@@YahooBaba thank you sir ❤️
hello sir , i have questions k foreign key to point krta he dosrey table k column ko jo k apne banaya CITYNAME k name se to CITY kese foreign key bana ? 2nd yeh k apne is tutorial main personal table k column city ki values to khud insert karwayen hain .. is ko khud pick nae hojana that city table se ?
1) Dekho ek table ki PRIMARY KEY point karti hai doosre table ki FOREIGN KEY KO, tabhi dono table join hote hai.
2) Dekho koi bhi value apne aap insert nahi hogi kisi table mein. Yha toh basically hum khud insert kar rahe hai leking jab MySQL ko kisi langauge ke sath use karenge jaise PHP toh wha se ek aisa system banayenge ki value khud insert ho jaye.
Yii2 framework ke videos bnaoo bhai UA-cam uski videos hai hi nhi hindi me
SIR MA JAB TABLE KI SETTING PRE CLICK KRTA HO WASY HI MERA MYSQL OFF HO JATA HA
sir your all videos are awesome ad you are doing great job, but in this video i felt it needed more explanation.
Sir altering the table is complicated since the data type of my city column in personal is Varchar and then making it a foreign key requires to change it's data type later it has messed up my table.
sir thankyou and!
sir hum id ko primary na set kare tw bhi kaam chal sakta hana q.k iska koi khas kaam tw nhi hai ?
Nahi bina Id ko primary set karne se kaam temporary hoga kyu ki duplicacy aa jayegi aur Kisi ek column ko primary key set karna zaroori hai agar aap baad mein joins bhi karna chahte ho
12:34 raam kumar and sarita kumar are struggling actors
Sir I'm getting this error :
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(id), FOREIGN KEY (city) REFERENCE City (cid) )' at line 8
May be datatype of PRIMARY KEY and FOREIGN KEY is not same.
Same error
How to set two foreign key from two different references table?
Sir, foreign key command kam nahi kar raha hai, kya karu.
bhai maine 2 table banaya hua hai dono me primary key dala hua hai ab mai dono ko alter wale se foreign key banana chahta hu .bhai help kr de yar ho hi nhi raha hai
mera bhee nahi hotha for some reason
sir foreign key aur primay key ka naam same hona chahiye na parent table ki primary key hi to child table ki foreign key hogi par yahan to aapne primary key CID ko banaya hai aur foreign key city leliya please explain
अध्यापकजी नमस्कार इस टेबल का पारिवारिक रिश्तो पर विडियो बनाकर बताये जिसमें पुत्र, पुत्री, माता, पिता,दादा, दादी, काका, काकी, बाबा, बडिया, भुवा, फुंफा, इसके अलावा नाना, नानी, मामा, मामी, मासा, मासी के साथ साथ गाँव का नाम, जाति का नाम, भी हो
देखने का तरीका दायें से बांये 1आई डी नम्बर, 2 गांव का नाम, 3 जाति 4 नाम 5 सम्बन्ध (स्वयं, पत्नी या पति, पुत्र, पुत्री ) 6 नाना का नाम जो ओटोमेटिक बनेगा
Sir python par video banyi plzz hindi ma
Sir very nice lec please share pdf
Writing same code but i got an error "cannot add or update a child row"
Please help sir
Student table main city column main cid ki value dynamically kesy save krwaty han
Yes, i also want to know Yahoo Baba sir ????
Woh hum nahi karate hai wo toh khud generate hoti hai agar aapne table banate time cid ko AUTO_INCREMENT set kiye hoga toh.
@@YahooBaba ni sir main php ki baat kr raha hon. Us main aisa agar aik table main user ka data ho or second main koi comment ya post etc... to hum phir ye command kesy likhain gy k jo user waly data main id 4 ha us ny ye comment kia ha jo second table main save ha ...... to user waly id sy kesy pata chaly ga k kis user ny kon sa comment kia ha... main dating website py kam kr raha hon
SIR yeh code run nahi ho raha hai sir usme error a raha hai
1) sir yahi chees workbench ki jagah phpmyadmin pe banake dikhaona please usme dikat ho rahi hai
2) sir workbench software me alter table command try kiya pr nahi ho raha hi
Yes sure :)
@@YahooBaba Thanks and i m waiting :)
Sir why you have taken city data type in personal table as INT ?
FOREIGN KEY SHOULD HAVE SAME data type as primary key of another table?
Because in another table "city" their is a column name "cid" whose data type is INT and that is also a PRIMARY KEY of "city" table.
is this necessary to name of both column be same like u_name = b_rented_user => should it be u_name
NO
Can't understand why 33 people dislike this video 😳😕
error 3780 _ foreign key column data type =references key column k data type, same hona chahiye
Nhi samajh aaya
So sad 😢😢😢
Hi sir , If Primary key= Unique + Not Null , then there is no need to give NOT NULL as a constraint in ID column ....right ? replay Sir
Yes your thought is right but we can only make Primary key to any column if it is NOT NULL.
@@YahooBaba ok
sir data type same reta h dono ka shuru m varchar and int bata rahe ho and baad m int int bata race ho.
sir yeh chez clear krdain taake tutorial agey barhey .. inner join bhi isi se related he to aur samajh nae aega
Yes koi bhi join isi se realted hai.
1196 error showing whenever using rollback
it said non-transactional tables can't be rolled back