Yes you can do this with the help of "EVENTS" in mysql. Read this article for that : stackoverflow.com/questions/38886839/how-can-i-run-a-query-in-a-specific-time-using-mysql-or-php
very nice sir.sachi bahar se course kiya to kuch ni samjhaya aise deeply.confused rehti thi. k yeh kaise krna hai tab tk toh course bhi bnde ka khtm hone ko ajata hai.mujhe lga mera hi dimag kam hai :P .sir se puchti thi apko kaise PHP agai samnjh.pr apki videos se 5 min mein itna achi trh se smjh ata hai k bnda khud krle solve fir. thankyou so much.
thank you sir: this is my MySQL statement : SELECT courses.coursename,courses.Fee,COUNT(students.courid) FROM students INNER JOIN cities ON students.cities=cities.enrollno INNER JOIN courses ON students.courid=courses.courseid GROUP BY students.courid ;
@@gauravjha7875 ap ke behan sy ? G ap salay ho meray ..... You don't know ... ap shadi per bee aye thy .... I have fucked your sister ... when we both are in mood . Ufff what's the feeling that your sister gives me ..... She is very good .
@@gauravjha7875 teri behan ky sath, shadi ke hue ha ..... Uff your sister is too much beautiful... I fucked her when we both are in mood. You can't imagine that how we are satisfied. She love me... she give me satisfaction by her gorgeous body, when i am in tension. Bus yrr kia bataon rateen kitne haseen or din kitnay rooshan hoty hain us ky sath, jab woh meray or ma us ky kapray utarty hain.
@@YahooBaba haa sir but jab video watch karta hu tab samajme nehi ata hay is video ka sr no kaya hay fir video ko close karne ke bad thumbnail check karna padta hay
2:00 Sir u said humne in Cid ko save kraya h Student table me to sir save kaise kraya h ,if Inner Join se save kraya h to hum select command laga ke saare columns dekh skte hain to fir prblm kya h
City table Mai cid column aur courses table Mai crid column Ka primary key Hona jaruri hai hmra tbhi hm endono tables ko student table se join Kar skte hai ?
Sir student.table doesnot exist ka error aa raha hai hala k mainay koi extra table nai banaya courses ciry aur personal k ilaawa is problem ko kesay solve kru kindly bata dain
Sir category and sub-category se Product add karne pe jis category ki sub-category nahi hai wo Data Show nahi ho raha hai join category ka use karke please help me I m developing E-commerce website.
Sir, To inner join,left and right join the two tables is it compulsory that one table should contain primary key and another foreign key? Without foreign key and primary key can we join the tables?
hello sir i just finished your html and css tutorials . can you please tell me about any website to get projects related to html and css for practice only . Not any freelance marketpalce.
Please reply fast it's urgent... After doing all data hi visible nhi ho raha h I mean join ho raha h but rows create nhi ho rhe h. Maine jo 5 tables the unme data fill kiya h 3 rows h sabme but join me data q nhi aa raha h...?
@@YahooBaba SELECT p.id,p.name,p.per,p.age,c.cityname,cr.course_name FROM personal p INNER JOIN city c ON p.city=c.cid INNER JOIN courses cr ON p.courses=cr.course_id; that's my join query ,after joining three table I want show only Btech course student, where to write WHERE clause statement
Foreign key leni jaroori nahi hai JOIN ke liye. Primary Key jaroori hoti hai. Waise mera suggestion he ki Foreign key leni chahiye hai for security reasons.
HELP!!!!!!!! PLEASE SIR.... SIR problem ye hai ki ... hamara jo table hai i.e personal, to sir ye table 2 foreign keys ko store kar raha hai i.e cid and course_id question ye hai ki inke values ko aapne 1,2,1,2,1,,2,3 kyu likha jabki city ke table mein 5 city ke name hai...???? aur sir hame to pata nahi ki kaunsa banda kis "" cid """ se hai to hum randomly personal table k cid column mein values kyu bhar diye??? question 2 : table mein same id ko 2 baar likh diya maine like 1,1,2,3,2 then isko update kaene mei bahot dikkat aa rahi hai.please help kariye!!
Answer 1 : Dekho personal table mein cid and course_id isliye save kiye hai kyu ki personal table heavy na ho jai. Agar usmein pura city name likhenge toh wo table heavy hota jayega. Tabhi wha sirf unique id save kiya hai aur usko show karne ke liye JOINs ka use kiya hai. Answer 2 : Dekho table banate time mein he id column ko aapne UNIQUE set karna hai taki id duplication na ho. Aap CREATE Table aur Constraints wala video dubara dekhiye. ruclips.net/video/HAWQu5jx_8Y/видео.html
one more help please!!@@YahooBaba Sir bas ye samajh aa raha >>> City Column ke cid mein 1,2,3,4 id hai to phir hum aise kaise Personal table ke city column mein 1,2,3,4 put kar sakte hai... ... example >> personal table ke id=1, name=ram, city=1( yaha 1 ke jagah 2 ho sakta hai, where 1= agra and 2=delhi) city table ke cid= 1 (agra), 2 (delhi), 3 (mumbai), 4 (bihar). ....mujhe nahi pata ram kaha se belong karta hai... wo kaise pata chalega?? to kya mujhe personal table ke city colimn mein city table ke cid column ke 1,2,3 dekh kar values put karna hoga personal table ke city column mein ??
Dear hum MySQL database mein kuch bhi manually nahi dalte hai. Iske liye hum kisi server side language ka use karte hai jaise PHP. Hum user ko sirf city Name dikhanyenge aur jab wo FORM save karega tab database table mein "cid" save karenge.
Foreign key dono table me nai ho rhai sirf city vale table me ho rahi he Or courses me karte he to error aarha he error: 150 foreign key constraints is incorrectly formed How to fix this poz any one reply
Whatsapp number toh main share nahi karta hun kyu ki thoda busy hota hun development ke kaam mein, lekin aap mujhe email kar sakte hain hello@yahoobaba.net
Kamal ka samjhaya....koi bhi easily samjh jayega
Best way to learn SQL.
Great teaching skills thanks a lot .
Thanks and welcome
Im taking help from your videos for my final year project. Thanku soo much for sharing such content
Glad to hear that 😊
@@YahooBaba bhai department konsi hai
Kaafi mehnat lagti aise videos banae me aur itna clear padhane me..respect sir
Thanks and welcome :)
wao .sir mujhay joining kabhi samujh nhi eye lkin apkay lecture kay bad sub kuch samugh may aa giya
Thanx a lot sir, this is great channel I've ever seen in RUclips
is there is any posibility to set the execution time like in js we use settimeout and thanks for making this series sir !!!!
Yes you can do this with the help of "EVENTS" in mysql. Read this article for that :
stackoverflow.com/questions/38886839/how-can-i-run-a-query-in-a-specific-time-using-mysql-or-php
@@YahooBaba Thanks its really helps !!!
very nice sir.sachi bahar se course kiya to kuch ni samjhaya aise deeply.confused rehti thi. k yeh kaise krna hai tab tk toh course bhi bnde ka khtm hone ko ajata hai.mujhe lga mera hi dimag kam hai :P .sir se puchti thi apko kaise PHP agai samnjh.pr apki videos se 5 min mein itna achi trh se smjh ata hai k bnda khud krle solve fir. thankyou so much.
Thanks Tanu for appreciating my work :)
Sir very nice
Best course... I just continuously watching from last 3 days 😊 and soon full complete the course 😊
thank you sir: this is my MySQL statement :
SELECT courses.coursename,courses.Fee,COUNT(students.courid) FROM students INNER JOIN cities ON students.cities=cities.enrollno
INNER JOIN courses ON students.courid=courses.courseid
GROUP BY students.courid
;
best video so far
Tnx bro
from today I am starting to make job portal for my practice and was confused how to join multiple tables and this helps me thanks.
Your welcome :)
php print "thank you soo much, it is very helpfull.
Glad it was helpful!
thank you sir🙃🙃😊😊😊🙂🙂🙂😇😇😇😇
Very beautifully explained. Thanks
Thank you so muchhhhh sir..... this means a lot to me........keep growing sir ji............🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Most welcome
Thanks
Totally clear y Al topics thanks so much
Zaida clearkrta ha toh shadi kr loo is sy .....
Or sex krty wqt bee yehe smja kro.
o bhai bhai bhai kya samjhaya hai yaar aapne bahut bahut shukriya
Thanks and welcome :)
Thankyou so much sir your video is too amazing every consept are cleared....
Your welcome :)
Sir u r great teacher
Thank you sir
Thank you sir very helpful video for me
Awesome sir...
Best teacher
Thanks and welcome :)
acha sikha rahay hai thumps up dear
Thanks khawar :)
Thank you sir making for such these kinds
of videos ..
I'm glad you like it :)
Wooow great explanation 👌👌👌
Glad you liked it
nice teach
Very good Explanation 👍👌
Thanbks Naresh :)
Very nice sir . Pure youtube par apke jaise koi nahi samjhata
@@Zerocoment-zh6bq tune kar rakhi h kya???
@@gauravjha7875 ap ke behan sy ?
G ap salay ho meray .....
You don't know ... ap shadi per bee aye thy ....
I have fucked your sister ... when we both are in mood .
Ufff what's the feeling that your sister gives me ..... She is very good .
@@gauravjha7875 teri behan ky sath, shadi ke hue ha .....
Uff your sister is too much beautiful... I fucked her when we both are in mood. You can't imagine that how we are satisfied. She love me... she give me satisfaction by her gorgeous body, when i am in tension. Bus yrr kia bataon rateen kitne haseen or din kitnay rooshan hoty hain us ky sath, jab woh meray or ma us ky kapray utarty hain.
@@gauravjha7875 sala ha tu mera sharam kr.....
Sir ji har video ki title me video ki sr no ho sake to add kijiye 👍
Hello naps, maine already video ke thumbnail pay serial number dala Hua Hai.
@@YahooBaba haa sir but jab video watch karta hu tab samajme nehi ata hay is video ka sr no kaya hay fir video ko close karne ke bad thumbnail check karna padta hay
awesome
Nice and easy explanation 🎉🎉🎉🎉
Thanks a lot 😊
very good explanation
Thanks for liking
❤❤
make series on android studio
Love from Pakistan
Sir ap ke OOP ke concerpts mujhe ache lage lakin ap MySQL ki jaga phpmyadmin pr videos bana the to bohat acha hota
Fazal mujhe lagta hai aapko MySQL aur phpmyadmin ke bare mein pata nahi. PHPmyadmin mein MySQL ka he kaam hota hai.
Thank u sir
Sir aap video editing kese karte ho ye sav explain karne k liye ?
Nice
Thanks
@@YahooBaba ohh bhai,you are the first RUclipsr who replied to me
Thanks Sir
You are making quality content👍🏻
Thanks AK for appreciating my work :)
Awesome sir :)
So nice of you
2:00 Sir u said humne in Cid ko save kraya h Student table me to sir save kaise kraya h ,if Inner Join se save kraya h to hum select command laga ke saare columns dekh skte hain to fir prblm kya h
City table Mai cid column aur courses table Mai crid column Ka primary key Hona jaruri hai hmra tbhi hm endono tables ko student table se join Kar skte hai ?
Dekhiye Primary key lagana toh jaroori hai lekin Foreign key lagana jaroori nahi hai. Primary key ek unique identity hoti hai kisi record ki.
Agr city table me cid=5 me bhi city Agra huii toh student table me Agra ke liye kaunsi id jaayegii 1or5?
5 jaayegi.
How u added courses table in this
Sir student.table doesnot exist ka error aa raha hai hala k mainay koi extra table nai banaya courses ciry aur personal k ilaawa is problem ko kesay solve kru kindly bata dain
Sir how to insert data from one form in multiple table's.
aapne personal table update kiya hai kya. Mai aapke puri series follow kar rahi hu
Yes update kiya hai.
how to print same but whose age is min,
so just one row should be there whose age is 19
sir personal table mai ek hi time pe city and couses kaise aa rahe. Apne 2 foreign key set ki hai kya personal table mai city and courses ke liye
That is because of JOINS
text editor??
Sir category and sub-category se
Product add karne pe jis category ki sub-category nahi hai wo
Data Show nahi ho raha hai join category ka use karke please help me I m developing E-commerce website.
Usmein LEFT Join lagega.
@@YahooBaba thank you sir try krta hon
Personal table ke courses cOlumn ko Foreign key bnana padega ki nahi
Bana bhi sakte kyu ki koi compulsion nahi hai Foreign key banana. Han lekin Primary key banana jaroori hai.
@@YahooBaba thanks
Sir why you not give Foreign key to courses column
Sir, To inner join,left and right join the two tables is it compulsory that one table should contain primary key and another foreign key?
Without foreign key and primary key can we join the tables?
Yes Primary key are must to make JOINS in two or more tables but you may leave Foreign keys because it is not necessary to make foreign key.
@@YahooBaba OK Sir.. Thanks For your immediate reply...
@@YahooBaba Jb without foreign key kam chal jayega to hm use kyon krte hain sir??
@@Ram-Naresh kyuki hme data redundancy nhi chaiye isliye hum foreign key use krte hai and readibility shi hoti h agar Fk hoti h to🙂
@@khushiagarwal106 Thanks for reply but foreign key me data repeat ho sakta hai..
hello sir i just finished your html and css tutorials . can you please tell me about any website to get projects related to html and css for practice only . Not any freelance marketpalce.
Hello Usman I don't know any such type of website.
Sir, are you going to explain oops concepts in this PHP tutorial.. please answer me
Yes I will explain every topic in PHP...like Oops, Ajax, Jain, API Development.
how we set a frign key without query
sir ek table me 2 foreign key ko add karne ki Query alter command se
ALTER TABLE ORDERS
ADD FOREIGN KEY (column1) REFERENCES CUSTOMER(SID),
ADD FOREIGN KEY (column1) REFERENCES CUSTOMER(SID2);
Sir DBMS connection is not available error is come
That means no JOIN establish between your tables.
Good Day! have great achievements in life... i would like to contact you on social application> would you please?
Please reply fast it's urgent...
After doing all data hi visible nhi ho raha h I mean join ho raha h but rows create nhi ho rhe h. Maine jo 5 tables the unme data fill kiya h 3 rows h sabme but join me data q nhi aa raha h...?
Iska matlab hai ki join theekh nahi lagaya hai.
@@YahooBaba I used inner join..
4 table add krne pr "warning truncate ur data" likh k ata hai
sir suppose i want only btech student data table in that join how to write query
Show me your attempt of SQL command... I will correct it if it is wrong
@@YahooBaba SELECT p.id,p.name,p.per,p.age,c.cityname,cr.course_name FROM personal p INNER JOIN city c ON p.city=c.cid INNER JOIN courses cr ON p.courses=cr.course_id;
that's my join query ,after joining three table I want show only Btech course student, where to write WHERE clause statement
put WHERE clause at the end of the query.
@@YahooBaba Yes its working, thank you sir.
3rd table join kyasa hula osko to foren key pe nahi liya tha
Foreign key leni jaroori nahi hai JOIN ke liye. Primary Key jaroori hoti hai.
Waise mera suggestion he ki Foreign key leni chahiye hai for security reasons.
Sir foreign key use nahi ki he kya isme??
Hanji nahi ki hai
@@YahooBaba
Bina foreign key table access hota he kya Sir?
HELP!!!!!!!! PLEASE SIR....
SIR problem ye hai ki ... hamara jo table hai i.e personal, to sir ye table 2 foreign keys ko store kar raha hai i.e cid and course_id question ye hai ki inke values ko aapne 1,2,1,2,1,,2,3 kyu likha jabki city ke table mein 5 city ke name hai...???? aur sir hame to pata nahi ki kaunsa banda kis "" cid """ se hai to hum randomly personal table k cid column mein values kyu bhar diye???
question 2 : table mein same id ko 2 baar likh diya maine like 1,1,2,3,2 then isko update kaene mei bahot dikkat aa rahi hai.please help kariye!!
Answer 1 : Dekho personal table mein cid and course_id isliye save kiye hai kyu ki personal table heavy na ho jai. Agar usmein pura city name likhenge toh wo table heavy hota jayega. Tabhi wha sirf unique id save kiya hai aur usko show karne ke liye JOINs ka use kiya hai.
Answer 2 : Dekho table banate time mein he id column ko aapne UNIQUE set karna hai taki id duplication na ho. Aap CREATE Table aur Constraints wala video dubara dekhiye.
ruclips.net/video/HAWQu5jx_8Y/видео.html
one more help please!!@@YahooBaba Sir bas ye samajh aa raha >>> City Column ke cid mein 1,2,3,4 id hai to phir hum aise kaise Personal table ke city column mein 1,2,3,4 put kar sakte hai... ... example >> personal table ke id=1, name=ram, city=1( yaha 1 ke jagah 2 ho sakta hai, where 1= agra and 2=delhi) city table ke cid= 1 (agra), 2 (delhi), 3 (mumbai), 4 (bihar). ....mujhe nahi pata ram kaha se belong karta hai... wo kaise pata chalega?? to kya mujhe personal table ke city colimn mein city table ke cid column ke 1,2,3 dekh kar values put karna hoga personal table ke city column mein ??
Dear hum MySQL database mein kuch bhi manually nahi dalte hai. Iske liye hum kisi server side language ka use karte hai jaise PHP. Hum user ko sirf city Name dikhanyenge aur jab wo FORM save karega tab database table mein "cid" save karenge.
How to make multiple Foreign Keys ?
In the same way as we create a single Foreigh key.
@@YahooBaba Thankyou
Equi join , self join ..plz
In MySQL their is no Equi Join and also their is no self join in mysql we do it with Inner Join or Left Join
How to see students from agra and delhi together
use IN operator : ruclips.net/video/f17Xk4ZpMuY/видео.html
sql ke yeah notes milege sir
Get it from our website www.yahoobaba.net
@@YahooBaba sir isme aapki bas video hai notes nhi hai
Foreign key dono table me nai ho rhai sirf city vale table me ho rahi he
Or courses me karte he to error aarha he
error: 150
foreign key constraints is incorrectly formed
How to fix this poz any one reply
Paste your SQL command here...
I will tell you the error
Sir whatsapp number dijiye
Whatsapp number toh main share nahi karta hun kyu ki thoda busy hota hun development ke kaam mein, lekin aap mujhe email kar sakte hain hello@yahoobaba.net
Tnx vai
many many thanks
You are most welcome
thanks.
❤❤