SQL how to combine INSERT INTO and SELECT?

Question

MySQL

I have this SQL query.

SELECT url_img, object_id FROM images 
  INNER JOIN products ON images.object_id = products.id 
  WHERE images.object = "product"

From the images table, all fields are selected according to the given conditions.
But the task is to throw this result into the products table in the image_url field

INSERT INTO products (image_url)
SELECT url_img, object_id FROM images 
  INNER JOIN products ON images.object_id = products.id 
  WHERE images.object = "product"

UPDATE products
SET products.image_url = image.url_img
SELECT url_img, object_id FROM images 
  INNER JOIN products ON images.object_id = products.id 
  WHERE images.object = "product"

But nothing happens MySQL writes this:

Column count doesn't match value count at row 1

Answer 1

UPDATE `products`
  LEFT JOIN `images` ON `images`.`object_id` = `products`.`id`
  SET `products`.`images` = `products`.`url`

Answer 2

INSERT INTO products (image_url)
SELECT  url_img
FROM
(
    SELECT url_img, object_id FROM images 
    INNER JOIN products ON images.object_id = products.id 
    WHERE images.object = "product"
) AS t1