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...