Updating Data SQL

    Update Records in a Specific Row

UPDATE TABLE_NAME
SET ROW_DATA = 123
WEHRE EMPLOYEE_NUMBER = 34;

UPDATE MULTIPLE RECORDS AT ONCE IN THE SAME TABLE USING THE IN

UPDATE tbl_transaction
SET employee_number = 194
WHERE employee_number IN (3, 5, 7, 9);

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top