3 ms·
Well, the two initial ideas I had for joining are to join to itself, and to join to another image. For example: # Join image to itself but offset by one pix
by kbenson 11y ago
Well, the two initial ideas I had for joining are to join to itself, and to join to another image. For example:
# Join image to itself but offset by one pixel and report the average of the RGB values
SELECT (img1_pixel.red+img2_pixel.red)/2
(img1_pixel.green+img2_pixel.green/2
(img1_pixel.blue+img2_pixel.blue)/2
FROM img1 img1_pixel INNER JOIN img1 img2_pixel
ON img1_pixel.column = img2_pixel.column
AND img1_pixel.row = img2_pixel.row+1;
# Superimpose one image over another, offset by 100 pixels width/height
UPDATE img1, img2
SET img1.rgb = img2.rgb
WHERE img1.row = img2.row+100
AND img1.column = img2.column;