05_Update_rows.sql

update employees set hourly_pay = 100, hire_date = "2024=10=01" where employee_id = 6;
/* update employees set hourly_pay = 150; */ -- this will chage all values of houly_pay column to 150
/* delete from employees; */ -- this will delete all row from the table
delete from employees where employee_id = 6;
select * from employees;