Page Comparison

This article explains how to use the functions in MySQL using the app SQL for Confluence (Pro Edition).

Instructions

Follow the steps:

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.
   Image Modified
   

4. Select the Data source profile and write the SQL statement as shown in the below image.
   a. CONCAT () - This function allows you to add two or more strings together.
   

   Code Block
   language sql
   SELECT user_name, CONCAT( display_name," ", active," ",created_date) AS Userdetails FROM cwd_user;

   
   Image Modified
   Image Modified
   b. LEFTJOIN - JOIN ()A JOIN clause is used to combine rows from two or more tables, based on a related column between them.
   

   Code Block
   language sql
   SELECT * user_name,last_name,group_name FROM cwd_user LEFT JOIN cwd_group on cwd_user.directory_id = cwd_group.directory_id

   Image Removed

   ;

   
   Image Added
   Image Added
   c. LEFT () - Thisfunction is a string function that returns the left part of a string with a specified length. 
       In below example, the following statement uses theLEFTfunction to return the 5 leftmost characters of the stringMySQL LEFT.
   

   Code Block
   language sql
   SELECT group_name, LEFT(group_name, 5) summary FROM cwd_group;

   Image Added
   Image Added