.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
Scenario
Insert the SQL-file on a Confluence page using the Insert Macro menu and have the Macro reference a SQL file located within the /scripts (default) directory of your Confluence server.
Estimated Time: 4 min
Let's say you have a database table called "BOOKS" and the table contains the following columns and rows:
SQL > select * from books; +----+----------------------------+---------------------+-------+ | id | title | author | price | +----+----------------------------+---------------------+-------+ | 1 | The Grapes of Wrath | John Steinbeck | 12.99 | | 2 | Nineteen Eighty-Four | George Orwell | 8.99 | | 3 | The Wind-Up Bird Chronicle | Haruki Murakami | 7.99 | | 4 | Don Quixote | Miguel De Cervantes | 29.99 | | 5 | Pilgrims Progress | John Bunyan | 17.99 | | 6 | Robinson Crusoe | Daniel Defoe | 29.05 | | 7 | Gullivers Travels | Jonathan Swift | 15.98 | | 8 | Tom Jones | Henry Fielding | 13.59 | | 9 | Clarissa | Samuel Richardson | 13.59 | | 10 | Tristram Shandy | Laurence Sterne | 7.59 | +----+----------------------------+---------------------+-------+
