Hi Shanu , - in ALTER TABLE-RENAME COLUMN = in syntax - in 2nd line- There should be 'column' word needs to add =RENAME column old_column to new_column ....and in your example the term used MODIFY in 2nd line----i have tried with MODIFY word -its not working -showing error.
Hello Mam, in page ""4.ALTER TABLE-RENAME COLUMN "" your command is wrong , correct query is ALTER Table_name ,RENAME Column old_column_name TO new_column_name; ---->you forget to mention "column" word after RENAME .
At 26:39, there should be RENAME in place of MODIFY because in the syntax there is RENAME and we are renaming the column name. So, there should be RENAME, right ?
Clap clap clap 👏 👏 mam Crystal clear all the DDL commands . Very nice explanation of this. Love of study ❤❤❤❤❤❤
#secretstudylover❤
I think this series is one of the best and sequentially explained sql series....Thanks Mam....
Thanks mam. This channel is supper dupper helpful for DBMS students. 💯.
one of the best lecture ever.....heartstoling
Best Series of SQL😄😊😊😊
shanu mam your teaching skills and your persentation about this video are mindblowing .. my all doubt is clear now thanku so much mam....🙏
One of the best video on TH-cam... Really helping me out
Great. Huge Respect to you mam. This helps with the basics of SQL for beginners. Thanks a lot
NICE ILOVED WATCH YOUR VIDEOS
Great explanation mam
Hello Madam,
At 21:39 Can you check the foreign key constraint. I think it will be FOREIGN KEY (DeptID) REFERENCES Dept(Dept_ID)
Great video mam thank you for this..... Thank you so much.... ☺☺☺
Concept clear my dear madam
Wooo 🙏
Can you provide ppt
very good explained in hindi mam thank u soo much .very nice series . please make for deta scientiest series on python linux power bi ML.
Thank you mam
Waiting for the video DML commands😀
Stay tuned for upcoming videos and press bell icon......share and support
mam ispe aap oracle ka synatax bta rhi ki microsoft sql
Is ma jo datatype use ki han ap na wo oracle sql ka bases pe han ya my sql?
Mam thank you so much
thank you for the video mam..
Hi Shanu , - in ALTER TABLE-RENAME COLUMN = in syntax - in 2nd line- There should be 'column' word needs to add =RENAME column old_column to new_column ....and in your example the term used MODIFY in 2nd line----i have tried with MODIFY word -its not working -showing error.
Ma'am what more subjects u are going to teach and plz provide the ppt of the dbms lectures..
As for now u can take screenshots
@@ShanuKuttanCSEClasses ok ma'am that's also cool though thanks..once again.
Maam can you share all slides pdf related to SQL ?
Thank you mam
mam how can we delete database same as table or other method
Ma'am plz provide the notes toooo plz .
Hello Mam, in page ""4.ALTER TABLE-RENAME COLUMN "" your command is wrong , correct query is ALTER Table_name ,RENAME Column old_column_name TO new_column_name; ---->you forget to mention "column" word after RENAME .
Alter table rename query doesn't work in MYSQL..... what should I do...???.
Try this
ALTER TABLE tablename RENAME COLUMN oldcol To newcol
@@ShanuKuttanCSEClasses thank you so much🙏🙏 Ma'am it is working.....
threre is a mistake in rename example maam
At 26:39, there should be RENAME in place of MODIFY because in the syntax there is RENAME and we are renaming the column name. So, there should be RENAME, right ?
Respected mam
Please 🙏🙏🙏 provide me Lectures PDFs.
Ma’am notes milega
Mam can you send your notes...
Apne practicals kyu nahi kara inka
Thank you mam
Thank you mam