How to correctly change the value of a field from another table (mysql)?

Question

MySQL

There is a field_data_field_images in which you need to substitute the value for the fields field_images_alt and field_images_title from the title field, but already in the commerce_product table. These tables are connected by a field with id. In field_data_field_images this is the entity_id and in commerce_product this is the product_id.
Something like:
update field_images_alt = title, field_images_title = title
where entity_id = product_id and field_images_alt, field_images_title = empty

Answer 1

You can try like this:

UPDATE field_data_field_images fi SET fi.field_images_alt = (SELECT title FROM commerce_product cp WHERE cp.product_id = fi.entity_id) , fi.field_images_title = (SELECT title FROM commerce_product cp WHERE cp.product_id = fi.entity_id) WHERE fi.field_images_alt = null AND fi.field_images_title = null;