Unnamed

SELECT @statement := CONCAT('INSERT INTO joomla.jos_vm_product SELECT ', GROUP_CONCAT(	SELECT column_name 	FROM information_schema.columns 	WHERE 		table_schema="joomla"		AND table_name = "jos_vm_product" 		AND column_name IN (			SELECT column_name 			FROM information_schema.columns 			WHERE 				table_schema="mambo" 				AND table_name = "mos_pshop_product"		)), ' FROM mambo.mos_pshop_product');PREPARE myStatement FROM @statement;EXECUTE myStatement;DEALLOCATE PREPARE myStatement;