This article explains how to create a temporary table in MySQL database using the SQL for Confluence (Pro edition) app.
Instructions
Here are the step-by-step instructions:
- Login to the Confluence instance.
- Go to the required confluence page and edit the same.
- Add SQL macro and go to the Edit option to open the settings for SQL settings.
4. Select the Data source profile and write the SQL statement to create a temporary table as shown in the below image.
5. Click on Save settings.
6. To verify whether the table got created, please execute the select query in your database.
- The temporary table is visible only to the current session and dropped automatically when the session is closed.
- Use SQL macro for insert/update/create.
- It is recommended to test this function in a non-production environment before creating it in production.