Good afternoon.
I'm new to Database and I can not resolve this solution.
Assemble a clause that performs UPDATE, for all employees who perform the "Computer Programmer" function, changing its function to "Programming Manager"
Basic Commands
-6
asked by anonymous 28.06.2018 / 22:36
1 answer
2
Since no information was given on the structure of the case, a more "standardized" example to solve the problem would be:
UPDATE funcionario SET funcao = 'Gerente de programação' WHERE funcao = 'Programador de Computador' .
The SET will assign the desired value in the entered field and the WHERE will filter which records will change according to the given condition.
28.06.2018 / 22:44