Set Configurable product Second Image to Thumbnail Sql

[harmeetsandhu]

Hi All, 

I am in the process of migrating Magento 1.9 to 2.3 and hit a problem. Hope somebody can guide me please. 

Migrated all products across and in 1.9 i had hover image change based on an alt text which was built in the theme. The new theme takes "thumbnail image" as the hover image. Now all the products have the same image set to as "base", "small_Image" and "Thumbnail_Image". 

I am trying to find a way to set the second image of a configurable product to thumbnail via mysql

We have over 1500 products and doing it manually will take ages. 

Please help :-)

[Rakesh Jesadiya]

-You need to refer catalog_product_entity_varchar table for a relation of product with images in the database.

Check more details for images relation in database table, https://www.rakeshjesadiya.com/how-product-images-are-saved-in-database-magento-2/