Versions Compared

Old Version 15

changes.mady.by.user Manisha Kharga

Saved on

compared with

New Version 16

changes.mady.by.user Manisha Kharga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

  1. Login to the Confluence instance.
  2. Go to the required confluence page and edit the same.
  3. Add SQL macro and go to the Edit option to open the settings for SQL settings.

...

     5. Click on Save settings.
     6. To verify whether the table got created, please execute the select query in your database.
                   


Info
  • Use SQL macro for insert/update/create.
  • It is recommended to test this function in a non-production environment before creating it in production.
  • Ensure that the confluence-user has permission to access the SQL macro.