MySQL PRIMARY KEY & FOREIGN KEY Tutorial in Hindi / Urdu
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- 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 👍
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!
One of the best YT channel to learn programming
I will never forget this explanation
Your teaching skills are soooooooooooooooo goooooood sir
Thank you 🙏
Easiest way to learn _primary-foreign_ key. Thanks sir👍
zaberdast sir mind blowing super bhot acha samjhaya hai ap nay
Thanks :)
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
i am following your whole tutorial playlist for sql . it is really nice
Thanks :)
Your explanation is osm... Tysm🥰
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!
lovely explanation...to the point video... respect ++
Glad you liked it
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
It's A very Good explanation for me ... ❣️ And i Can't stop my fingers to Subscribe You ❣️❣️❣️
Thanks and welcome :)
GREAT sir ji👏🏻👏🏻🙏🏻😁
You came as blessing sir.... Thanku so much sir❤
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.
no one can teach better than this.. 🧡
Thanks for appreciating my work :)
brilliant teaching 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 :)
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.
perfect example sir....... thankyou sirr...
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
in student table city should be in INT that is cid and city both should have same length asa wll as same datatype.
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.
Hello sir store procedure pr video laye aap bahut achchhe se padhate hai
Sir g ERP SAFTWERE BNANE ME PHP KE SATH - SATH OR KON SA COURSE KI NEED HAI
There can be set of columns that can be primary key also 👍
Bhut vadia treke nl clear kita sir g thanks 👍🙏
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.
Great time I am having with this course to so much 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.
Excellent way of teaching..
The whole tutorial video playlist is the savior for me . Thank you so much for such detail explanation
Glad it was helpful!
your teaching skill are best
Thanks a lot
yar aapki voice my god kitni mst h jaise delhi metro me bolte h
Very well explained mysql Primary Key and Foreign key
Thanks :)
nice video thankyou
Sir personal table me insert row me last ka 1 liya he wo kiske base me liya he . Please reply.
Sir jaldi upload kro...please make as soon as possible
Brilliant sir...
Please make a project using php mysql javascript & ajax.
MySQL course ke bad project Shuru Hone wala PHP with MySQL
@@YahooBaba OK
Excellent explanation sir
Thanks for liking
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
sir you are such a greate techer
itna aacha syd hi koi pada apaya
Thanks for appreciating my work :)
SIR MA JAB TABLE KI SETTING PRE CLICK KRTA HO WASY HI MERA MYSQL OFF HO JATA HA
Thanks a lot sir😇😇😇🙂🙂🙂🙃🙃🙃🙃😊😊😊😊😋😋😋😋
Most welcome
THANKS SIR FOR THIS VIDEO IT REALLY WORK
Your most Welcome :)
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.
thank you for this useful videos
You are welcome
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.
very good explanation 🎊🥰
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
Very nice 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
Finished watching
The insert statement conflicated with the foreign key the conflict occured in database table column
Great
1196 error showing whenever using rollback
it said non-transactional tables can't be rolled back
Thank you sir
Welcome
thanks for every single video❤️❤️❤️🧗♂️
Your welcome :)
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 data type same reta h dono ka shuru m varchar and int bata rahe ho and baad m int int bata race ho.
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
Iske baad ak normal ER diagram iske upr bana k relation samaja k video banna chahiye tha
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, foreign key command kam nahi kar raha hai, kya karu.
SIR yeh code run nahi ho raha hai sir usme error a raha hai
Please make a video on powerbi
I think these people are more intelligent than me
I am unable to create table which includes primary and foreign key....everything is OK.. but still it is showing error like foreign key incorrectly formed..
Its mean that your foreign key is not correctly connect with Primary key of another table.
MySQL optimization ka video bhi bna lijiye sir
Sure
Sir, I'm working on a project integration with PHP via localhost (form submission/ form updation) my "submission form" step is complete but I've stucked in form updation integration with PHP,,,,, Please help me out.
Please follow this Playlist :
th-cam.com/play/PL0b6OzIxLPbzXPdt9pKeQXm6NoPA9MdKW.html
@@YahooBaba Thank you so much! I have no words to thank you for helping me out. I will explore your PHP MySQL playlist after completing my MySQL playlist...... I have watched full playlist of PHP before, Recently I'm learning MySQl. By the way, Thanks a lot! Love from Pakistan...
@@Muhammad_Naeem662 Your most welcome :)
अध्यापकजी नमस्कार इस टेबल का पारिवारिक रिश्तो पर विडियो बनाकर बताये जिसमें पुत्र, पुत्री, माता, पिता,दादा, दादी, काका, काकी, बाबा, बडिया, भुवा, फुंफा, इसके अलावा नाना, नानी, मामा, मामी, मासा, मासी के साथ साथ गाँव का नाम, जाति का नाम, भी हो
देखने का तरीका दायें से बांये 1आई डी नम्बर, 2 गांव का नाम, 3 जाति 4 नाम 5 सम्बन्ध (स्वयं, पत्नी या पति, पुत्र, पुत्री ) 6 नाना का नाम जो ओटोमेटिक बनेगा
Thanks a lot
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 ❤️
Awesome sir 👍😎
Sir im having one problem… can u plz tell me that where we can use CHAR instead of VARCHAR ?
We use CHAR where we only want to store 1 character. For example if their is "Gender" column then we only store "m" or "f" means "m" for male and "f" for female.
is this necessary to name of both column be same like u_name = b_rented_user => should it be u_name
NO
bhut achha bhut khoob
Thanks and welcome :)
thanks_Sir💜
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
Make video on postgresql
error 3780 _ foreign key column data type =references key column k data type, same hona chahiye
Primary key 2 column ke combination se bhi to ban sakti hai
Aila...kaise ?
Hello sir id auto_incrwament doesn't support in MySQL workbench
Because your increment spelling are wrong.
Make one more video on primary and foreign key
CREATE TABLE parent_table (
field1 INT,
field2 INT,
other_field VARCHAR(100),
PRIMARY KEY (field1, field2)
);
CREATE TABLE child_table (
field1 INT,
field2 INT,
additional_field VARCHAR(100),
PRIMARY KEY (field1, field2),
FOREIGN KEY (field1, field2) REFERENCES parent_table(field1, field2)
);
That is totally wrong. You can't make 2 or more PRIMARY Key in one Table.
Great brother nice job
Thank you so much 😀
Sir, i am getting the error ----16:20:40 CREATE TABLE STUDENT2 ( ID INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(50) NOT NULL, AGE INT NOT NULL, CITY VARCHAR(50) NOT NULL, PRIMARY KEY (ID), FOREIGN KEY (CITY) REFERENCES CITY (cid) ) Error Code: 3780. Referencing column 'CITY' and referenced column 'cid' in foreign key constraint 'student2_ibfk_1' are incompatible.
Could you please help?
i am also getting the same error.
bhai solve ho gya ho to btaa de yrr
Sir python par video banyi plzz hindi ma
Excellent
Any one nowadays ❤
Good
Writing same code but i got an error "cannot add or update a child row"
Please help sir
Thanks for
good job
kia hum (Primary Key) ID k agay nahi likh saktay like (id int not null auto_increment primary key)?
MySQL mein nahi likh sakte. Aisa hum Oracle mein likh sakte hai.
@@YahooBaba sir , koi mini projects ki site recomend kro
Yii2 framework ke videos bnaoo bhai TH-cam uski videos hai hi nhi hindi me
Sir I am getting error in foreign key
What is the error ?
@@YahooBaba foreign key constraint is incorectly formed