Learn about adding a new versioned migration script to the project folder.  Create a new Versioned migration script with placeholders and save it to your project.
Example:

# If your target databases have different names, you can use the default flyway:database placeholder
IF (${flyway:database} == "HR_DEV")
	INSERT INTO TBL_ENVIRONMENT VALUES ("DEV");
ELSE IF (${flyway:database} == "HR_TEST")
	INSERT INTO TBL_ENVIRONMENT VALUES ("TEST");
ELSE IF (${flyway:database} == "HR_STAGE" || ${flyway:database} == "HR_PROD" )
	INSERT INTO TBL_ENVIRONMENT VALUES ("PROD");
END IF
 

Learn more about placeholders.

When this versioned migration script is deployed to a target environment, it will replace the placeholder with it's corresponding value and run the correct insert statement.