#9 SQL Foreign Key in Telugu| SQL Full Course in Telugu| Foreign Key in SQL Telugu
Вставка
- Опубліковано 16 вер 2024
- #9 SQL Foreign Key in Telugu| SQL Full Course in Telugu| Foreign Key in SQL Telugu
Explained in very easy mode and every one can understand easily!!
Telugu Programming Tutorials -- HTML , C#, CSS, Java Script, PHP, .NET, JAVA, Interview Questions and Answers etc...
Sir meeru chala manchiga explain chestunnaru sql gurinchi deep ga videos cheyyandi sir like full course
Very nice explanation
We need all topics of SQL
create table statesInfo(stateid int primary key identity,statename nvarchar(50),statecode nvarchar(20))
insert into statesInfo values('AndhraPradesh','Ap')
insert into statesInfo values('Telangana','TG')
insert into statesInfo values('MadhyaPradesh','Mp')
insert into statesInfo values('Maharastra','MH')
insert into statesInfo values('Karnataka','KA')
select * from statesInfo
create table districtInfo(districtid int primary key,districtname nvarchar(50),stateid int references statesinfo(stateid));
drop table districtInfo
create table districtInfo(districtid int primary key,districtname nvarchar(50),stateid int,CONSTRAINT FK_StateID FOREIGN KEY (stateid) references statesinfo(stateid));
insert into districtInfo values(1,'mumbai',4)
insert into districtInfo values(2,'mumbai',4)
insert into districtInfo values(3,'bidar',5)
insert into districtInfo values(4,'chikballapur',5)
insert into districtInfo values(5,'Indore',3)
insert into districtInfo values(6,'Bhopal',3)
insert into districtInfo values(7,'Anantapur',1)
insert into districtInfo values(8,'Guntur',1)
insert into districtInfo values(9,'war',2)
insert into districtInfo values(10,'kari',2)
select * from statesInfo
select * from districtInfo
Will this work in oracle sql
Thanks bro. Your video is excellent
Verey verey level ayaaaa idhi 😊💕🔥❤️
your explanation is very excellent brother
very good explanation brother, keep doing the same
Foreign key assign chesina taravata ha 2 columns (district info,states info)ni Ela display chestam sir?
Select *from tablename
Tablename daggar a tablename ivvali sir
hi sir nadi oka doubt oka comp lo rendu tables create chesina tharwata ee oka table lo kuda foreing key constraint evaledu alantappudu manam table middel lo foreing key constrain echi aa rendu tables ki joins apply cheyadaniki untadaaa sir. Is it possiable sir
you r explanation is too good make more videos
Bro meru enka SQL vedios update cheyandi meru chala Baga explain chesthunnaru pls more vedios upload cheyandi
Thank you sir...😊
nice explanation you are the best....but no response from that mail to real time experience .
thanks alot bro
Very good explanation
amazing simple and nice explanation
It's good but the screen is not much clarity please see that
Nyc explaination sir
Intha arthamayyetatlu evvaru cheppaledhu. Nuvvu Sarvepalli radhakrishna anna🙏
sir can you please expalin the difference betweeen table level and coloum level
bro qlik view tool gurichi cheppandi bro
I have sent an email regarding sql real-time project on 25th Jul 22 but not received any response from the respective team.
Same I send 2 weeks back but didn't receive any mail from them
Foreign key class asala enni sarlu chusina ardam katle
anna userinfo table syntax chupinchu anna last lo
I have Intrest on real time project but if I need to pay for course I am not Intrested
both tables lo column id same udala bro.
select statename,districtname from statesInfo si join districtInfo di on si.stateid=di.stateid
Bro im interested on real time projects
sir e video chala speed ga cheparu
Your syntax not appearing..... Very small font is appearing
Zoom your screen with 720p clarity
Java Real time cheptara bro
bro where are you from
bro php chypu bro
16:03
Clear ga ledu
Nice