Page Comparison

This article explains how to create a temporary table in a MySQL database using the SQL for Confluence (Pro edition) app.

Instructions

Here are the step-by-step instructions:

1. Login to the your Confluence instance.
2. Go Navigate to the required confluence page and edit the sameclick the Edit icon (Image Added).
3. Add SQL macro and go to the Edit option to click Edit to open the settings for SQL macro settings.
   

            Image Removed

...

1. Image Added
   
2. Select Data source profile

...

           Image Removed

...

1. under the SQL statement section and enter the SQL statement as shown:
   Image Added
   
2. Click Save settings.

...

1. To verify whether the table

...

1. is created,

...

1. execute the

...

1. following query in your database

...

1. :
   Image Added