SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE products ( ID INT, NEW_IMAGE VARCHAR(255) ); INSERT INTO products (ID) VALUES (11), (22); CREATE TABLE images ( ID INT, PRODUCT_ID INT, FILENAME VARCHAR(64) ); INSERT INTO images VALUES (1, 11, '1.jpg'), (2, 11, '2.jpg'), (3, 22, '3.jpg'); UPDATE products JOIN ( SELECT PRODUCT_ID, GROUP_CONCAT(FILENAME SEPARATOR '","') IMAGES FROM images GROUP BY PRODUCT_ID ) images ON images.PRODUCT_ID = products.ID SET NEW_IMAGE = CONCAT('["', IMAGES, '"]'); SELECT * FROM products;