Hello Sir, Can we update a column name in a table on top of data type instead of removing and adding it again ? For example, I have column name as "EmployID" hence I want to change it "Employee_ID".
Hey my friend, blessed to discover your channel. I have only a simple enquiry as a newbie sql learner. What is the main difference between alter and update in terms of their application in sql? Thanks for taking time on this..
Sir,You really explain well in a simple manner. I refer your videos even for the Python Programs and learnt a lot.
Hi sir, your explanation is good. While I am using not null constraint iam getting error invalid use of null value. Can you please suggest me.
Sir please explain select(DQL) with all the conditions and clauses
Hello Sir,
Can we update a column name in a table on top of data type instead of removing and adding it again ? For example, I have column name as "EmployID" hence I want to change it "Employee_ID".
ya it 's working
Hey my friend, blessed to discover your channel.
I have only a simple enquiry as a newbie sql learner.
What is the main difference between alter and update in terms of their application in sql?
Thanks for taking time on this..
Hi
ALTER is used to change structure of database
Update is used to change the data in table
@@sundeepsaradhi What do you mean exactly by structure of database? Thanks
how to delete check and default constraints?
finished watching
Sir, what is schema