PG Certificate Course in Data Science, AI & Machine Learning by IIT Roorkee. Apply Now & Get up to Rs. 75,000 OFF! Offer Ends in:
Apply NowLogin using Social Account
     Continue with GoogleLogin using your credentials
Values of one or more columns of a table can be updated with the 'update' command to store new required values.
Syntax:
update table_name SET field1 = new-value1, field2 = new-value2
[where Clause]
Example:
update deptt
set depcity = 'Pune' where depstreet = 'Laker Street';
update deptt
set depopendate = STR_TO_DATE('20170610','%Y%m%d'), depstreet = 'Saker Street' where depcity = 'Mumbai' order by depid desc limit 1;
select * from deptt ;
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
No hints are availble for this assesment
Answer is not availble for this assesment
Loading comments...