Thank you so much Sir Ji...you have changed my Java life.🙏🙏🙏
@sujatabiswas41973 жыл бұрын
Thanks Durgesh.. Amazing video. Please make separate video explaining JOINS (Inner, outer, left, right). ALso would be really helpful if you can pass on the notes that you were writing on Notepad.
@mytubeamit15932 жыл бұрын
Hi
@mechanosys2 жыл бұрын
I am not from IT but a mechanical engineer, 53. I was surprised that this was so easy to learn SQL. I am used to MSAccess, so very easily learned MySQL with all installation as per your video! Thank you DURGESH!.
@pranuthiprasad61033 жыл бұрын
This is the best explanation i have heard, please do more vidoes . Thanks
@sonalkale6392 жыл бұрын
54.55 assignment answer- alter table [table_name] rename column [old col_name] to [new col_name]; alter table student rename column country to state;
@shaktidash16752 жыл бұрын
bro.. i also tried by this syntax, but some error there. Can u explain?
@surajkamble482 Жыл бұрын
Bhava thank you 😊 you are Right
@mdtariqueazeez92132 жыл бұрын
To rename column use cmd-alter table table_name rename column old_column_name to new_column_name; To change the datatype of column use cmd- alter table table_name modify column_name datatypes; Thank you durgesh sir to provide this wonderful video
@diyanegi52 Жыл бұрын
TO RENAME COLUMN ALTER TABLE TABLE NAME CHANGE OLD COLUMN NEW COLUMN DATATYPE
@janakjadhav49093 жыл бұрын
Easiest method of teaching, even a school students can also learn without any doubt Absolutely fabulous work sir...😊😊😊
@kmtfarhan2 жыл бұрын
Clear MySQL basics after so many month and found this video to be of great use. Excellent work, Durgesh!
@OmParkashSarangani2 жыл бұрын
Revising MySQL basics after years and found this video to be of great use. Excellent work, Durgesh!
@kidzzone441 Жыл бұрын
Theek hai om Parkash😂
@niteshyadav5159 Жыл бұрын
@@kidzzone441 funy guy🤣🤣
@jawadazimi8607 Жыл бұрын
PPT and source code is not in here dear Your teaching is great.
@madhurigupta84943 жыл бұрын
this was really helpful, maine first time MySQL window open kia and i was totally clueless..... by the end of these 2 hours I was amazed! thank you so much!!
@prithvichauhan9507 Жыл бұрын
Hii, Durgesh please provide me the notes of this video as soon as possible .
@sanjitpaul29533 жыл бұрын
Great Sir. Learned overview of MYSQL within a short time. Your teaching style is excellent. Thank you.
@p2kgaming407 Жыл бұрын
Bhaiya mujhe smjh thora aaya coding krte time mera mind blank ho jta h kya kru 🥲🥲🥲🥲
@FaizanFurqanAhmad Жыл бұрын
Practice makes us perfect 😉
@gurpreetbains91963 жыл бұрын
31:45 at this moment I laughed alot because i can relate this😂 (pata ee nahi he)
@indiancomedyandhindisongs85843 жыл бұрын
0000p0pp0
@krankumarsharma28952 жыл бұрын
select * from student where city like '_u%' Video :- 1:27:08
@sanjaykumar-gz1zg3 жыл бұрын
For changing column name Mysql> alter table [table name] change [old col name] [new column name]: Right na bro..
@abbasahmad66432 жыл бұрын
alter table [table name] rename column [old col name] to [new column name];
@tshende02 Жыл бұрын
Yes , somehow your videos are good but to increase the watch time u repeat the same sentences again and again, that is not good u should respect our time.
@riteshdangi74604 жыл бұрын
need one more video on joints in details
@aliyaabbas95563 жыл бұрын
can you send me the notepad quires please or how i contact you Thank you for your help
@amithghosh33324 жыл бұрын
auto_increment and default values u havent explained? no matter!!; i am so happy with your methodology in teaching..... u covered every basic details whatsoever!!!!
@KumarHemjeet3 жыл бұрын
@Reginald Waylon bots !
@suyashbhargava48272 жыл бұрын
Thank-you so much sir Please give me notes
@venkatasimham47293 жыл бұрын
Thank you Durgesh. It was very refreshing to get a brush up on my SQL skills on very basics which I've learnt long back. I wish there were more type of joins added in this video. Still thank you again for all the efforts.
@eshwarkanna30672 жыл бұрын
ALTER TABLE [TABLE_NAME] RENAME COLUMN [OLD_NAME] TO [NEW_NAME] ;
@nishanthedaoo89374 жыл бұрын
Hello sir, Wapms server me jo mysql database hai use use kar sakte hai kya Eclipse? Thank you 😊
@spdeshwar8225 Жыл бұрын
In the history of KZbin prospectus of MySQL this vdo is best vdo of all ❤❤❤❤❤❤❤❤❤❤🎉🎉🎉🎉🎉🎉🎉🎉🎉
@anjubirla69763 жыл бұрын
Sir thanks to you a lot .I have to upload my journal which includes mysql work for practical exam in boards . I could not understand what my teacher was teaching and I thought I was going to score very less in this chapter.I invested my 2 hours and now I am an expert and also I can answer questions what my teacher can ask.Worthy 2 hours
@oneclick8403 Жыл бұрын
reallly😅😅
@Treeman1434 жыл бұрын
Sir ek video bootstrap 5 ko offline use karke ek video banao
@gamerboi383873 жыл бұрын
Thank you so much bro.. u made things clear in just 1and half hour .... I fully understood the concepts.. Thank you so much
@zeeshanahmad-tx5hw3 жыл бұрын
Great Sir..... Good videos.... Thanks
@shrutikakadam96773 жыл бұрын
Great Sir. Learned overview of MYSQL within a short time.
@someshsahu46382 жыл бұрын
Very nice explanation thankyou so much sir 🙏🏼🙏🏼🙏🏼
@nikitanaik1782 жыл бұрын
Great Video Sir! Can you also make a separate video on Joins concept with example & explaination?
@ravikantverma1642 Жыл бұрын
Very nice information. I am Je mech but u make sql very easy.
@ravikantverma1642 Жыл бұрын
Plese send ur note
@pankajsangle27523 жыл бұрын
Next one small video should be the real time implementation of database queries in any any project.
@spdeshwar8225 Жыл бұрын
Alter coll.old name rename new name
@BilluAck4 жыл бұрын
Sir NoSql ka bhi banaiye in one video please🙏🙏🙏🙌🔥🔥🔥
@amithghosh33324 жыл бұрын
yes, I want it too :)
@lofivibes4you2 жыл бұрын
Sir dont mind I am just kidding so my question is that in this video the last topic is join or foreign key on that the beginning part where you just show two tables on the first there is two name "" Durgesh or vandna "" .. So Vandna is your girlfriend 😀
@LearnCodeWithDurgesh2 жыл бұрын
Sister***
@lofivibes4you2 жыл бұрын
@@LearnCodeWithDurgesh i am really sorry i just imagine that why i was asking..:'(
@vaibhavshukla16853 жыл бұрын
thanku bro your definetly a good teacher who have the ability to vanish the doubts of your student. I am proud to see your video . Now i know mysql better.. thanku.. keep it... One suggest from my side my make a video all the concept of Database management system..
@as.editz.2 жыл бұрын
Tq sir 🙏🙏🙏🙏❣️❣️❣️❣️🥀🥀🥀🥀
@rahulchauhan1443 жыл бұрын
Now, That's what I call a perfect video, it had both Installation and Learning tutorial, Very Good ! Your Channel has been Subscribed :)
@aashadeeptechnical18982 жыл бұрын
U r great sir ..the way of teaching ..and ..the sequence ...to connect one problem with another and give sol in esiest possible way ....is amazing sir
@ArjunKumar_012 жыл бұрын
Thank You So Much Sir
@tarunchauhan10253 жыл бұрын
Thanks sir.. I love the way you explained .... very very good job sir ji... You are Excellent. Keep uploading Videos ..
@Abhinay461 Жыл бұрын
Thank you sir ❤️
@pankajkumargupta708 Жыл бұрын
Sir notes Chhiye pankajkg0825@gmail.com 🙏❤️
@bodyart1460 Жыл бұрын
very helpful thank you
@devendrapandey31242 жыл бұрын
Foreign key and join nahi samajh me aya... Baki sab samajh me aya.. Thanks a lot👍👍
@p2kgaming407 Жыл бұрын
Bro foreign key main bss yahi dekhna h dono table main ek jesa column or value pr depend h same h to foreign key
@tejaskumar60562 жыл бұрын
ALTER TABLE table_name CHANGE old_column_name new_col_name Data Type;
@goldenicons96602 жыл бұрын
Change column name command-: alter table table_name rename column (type old column name) to (type new column name); ex. alter table student rename column country to nation; 100% Working...........
Change column name. 👉👉👉👉👉👉 Alter table [table name -for eg(college)] rename column [column name -for eg(fess)] to [new column name -for eg (country) ]
@krishnakawade71363 жыл бұрын
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'creat database krish' at line 1 what type of error is this;
@vaibhavsharma69763 жыл бұрын
use create
@anjalidevi462 жыл бұрын
Alter table [table_name] change old_col_name new_col_name; Alter table student change country state varchar(50);
@vikashyadav-xn5md Жыл бұрын
Hi, Great work brother. AAP mjhe phle kyu nhi mile bhai !!!!! send me the link for notes as well ... continue with your remarkable work ...
@anishamalode53262 жыл бұрын
Thank you for the tutorial
@arpitsri96312 жыл бұрын
Hi friends 🙏👍
@tshende02 Жыл бұрын
well i thought my-sql has some different commands and at the end of this video i got to know that it is same as other database.
@Debasispat5253 жыл бұрын
thanks sir u r the best
@MuhammadAli-fo2sj3 жыл бұрын
Good SQL server VS MySQL
@vk192 жыл бұрын
Hi bro Very informative video I made notes on mssql I subscribed ur channel. Thank you and keep going
@Imkrisharma2 жыл бұрын
Sir plz ek full length course lekrr aaae KZbin pr in which you will explains full python programming from basics to acidic
@suriyab8143 Жыл бұрын
Which software are you using for recording this video?? Kindly let me know. Thanks in advance
@Amit-tn5fq Жыл бұрын
Best video 👌✌️
@priyankapatidar_CSАй бұрын
It's very helpful and easy to understand thank you so much sir..❤
@RAKESHGUPTA-ct7gp2 жыл бұрын
Sir I can't able to download my sql community server 8.0.28 please help me
@shiprasingh9541 Жыл бұрын
This video is awesome Thank you so much sir Your teaching style is very nice I have huge problem in SQL but this video is much help
@surajmukhiya2643 Жыл бұрын
Too grateful sir. Please make more videos In this I.e. MYSQL
@TanayOjha250889 Жыл бұрын
Very nice Durgesh good for beginners... But make some videos for professional also
@ahsanalimughal3701 Жыл бұрын
Rename alter table student rename column country to state; change datatype alter table student change id to std_id varchar(50);
@saikumar-kk1kh Жыл бұрын
please Explain us slowly.......🙏🙏🙏durgeshh🙏🙏🙏🙏
@SurajWankhede-ng3eb5 ай бұрын
55:02 alter table student modify name to person varchar (50);
@ScientificMyths27062 жыл бұрын
1:21:36 "like always important hota hai" .. Lagta hai bhai ne youtube video dil tootne ke baad banana start kiya hai.. BDW great revision course . It would have been more informative if you included exception handling , priorities and more on different type of joins.
@janendersharma77123 жыл бұрын
Simply add the notepad link in description box against personally mail to everyone.
@ahpatel100 Жыл бұрын
Which version of . Net Freamwork installed?
@rameshavaghad6966 Жыл бұрын
Sir , one question asked in interview..remove duplicate row from table..how it do
@divinecreations19 ай бұрын
Thank you so much for amazing video really very helpful, please share notes with me
@surajkumarrajput6347 Жыл бұрын
thank you so much sir this one-shot video was very helpful and i just got each and every detailed concept very clearly and the content was to the point . thankyou so much sir 🙏🙏
@M1P1... Жыл бұрын
Sir temporally RAM SSD permanent store bhut why use sql
@sagarmuttireddy24772 жыл бұрын
understood bhaiya thanks for video make video on plsql also bhaiya.
@shubhama02 жыл бұрын
Send notes
@wolfspack54832 жыл бұрын
I don't able run query... when I type show database; and tap enter it shows error.... can you please help me...?
@AYUSHKUMAR-ml5il2 жыл бұрын
alter table student change country region varchar(80); and sir this is for changing name of column and at the same time datatype also.
@harshkaira9453 жыл бұрын
58:35 lol
@sahilnayak65888 ай бұрын
Very helpful, as per basic level so much covered in this vdo thanku so much brother ❤
@jaychopra89322 жыл бұрын
how to add serial no. column in my existing table which have 30 rows (in mysql)
@riyadeb29883 жыл бұрын
Thankyou so much this video us helpful... Want to know more about it...
@arpitsri96312 жыл бұрын
Hello 🙏👍
@nileshkshatriya58272 жыл бұрын
Please don't do spelling mistake deliberately i know you want to increase the video size but this is not way to increase the video size it was so irritating when you do spelling mistake deliberately ...Please don't do that
@moulaalihujare6939 Жыл бұрын
select * from sanam where id between 20 and 30 order by id desc; .... this query also works;
@divinecreations13 жыл бұрын
Thank you so much it's really good Please send me notes
@abhilive01562 жыл бұрын
Alter table [tb_name] Raname Column oldcolumnName to NewcolumnName;
@Aditya-jk8qr2 жыл бұрын
When I download it shows there's no mysql server package
@gamesunboxingwithkd11743 жыл бұрын
Notes
@saivenkat36072 жыл бұрын
you forget to explain group by, sybstring, count...etc many more
@tusharverma25596 ай бұрын
To change column name alter table student rename column name to first_name;
@believer-n3t2 жыл бұрын
Bhaiya hum log script ( file ) ka use kyon nhi karte he data ko store karne ke liye, alag se software kyon chahiye🤔🤔🤔?? Reply please
@Vithal_Nivargi Жыл бұрын
Best Video! sir, please make video on JOINS
@prashantnarlawar10582 жыл бұрын
Thank you Durgesh. your video very nice and very ease understand....
@naveent279910 ай бұрын
Its really good video, Are you doing cloud computing videos as well ?