Sunday, September 13, 2015

SQL -- Updating Data in Table

Here is the current table:



(1) Arun Shah was promoted to Software Engineer II.

update myemployees_RDP0680
                set title = 'Software Engineer II'
                where title = 'Programmer




(2) Mike Jones birthday is today. 

update myemployees_RDP0680
                set age = age+1
                where lastname = 'Jones' and firstname = 'Mike'






No comments:

Post a Comment