SQL QUERY TO UPDATE DATA IN A TABLE

INSERT INTO EMPLOYEES(MNG)

VALUES(5256543)

WHERE ‘EMPLOYEEID’ = 5259876;

 

UPDATE EMPLOYEES

SET MNG = 5256543

WHERE EMPLOYEEID = 5259876;

 

UPDATE EMPLOYEES

SET MNG = 5256543

WHERE EMPLOYEEID = 5258765;

 

UPDATE EMPLOYEES

SET MNG = 5256543

WHERE EMPLOYEEID = 5257654;

 

UPDATE EMPLOYEES

SET MNG = 7881234

WHERE EMPLOYEEID = 7885432;

 

UPDATE EMPLOYEES

SET MNG = 7881234

WHERE EMPLOYEEID = 7884321;

Questions