Have you had experience performing data update operations in a database?

Yes, I have experience performing data update operations in a database. This was usually done using SQL queries like UPDATE, where I updated values in tables based on certain conditions. For example, updating the order status or correcting user data. In QA automation, such operations can be used for preparing test data or verifying the correctness of the application when data changes.

A simple update query example:

UPDATE users SET status = 'active' WHERE last_login > NOW() - INTERVAL '30 days';