Skip to main content
Inspiring
Oct 6, 2023 7:46 PM UTC
Solved

SQL to Excel

Hi, I am tying to run the Mysql to Excel plug-in: with basic SELECT Queries it works: but if I sent something similar to this:  

SET @pivot_sql = 'SELECT * FROM report'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; 

 it shows MariaDB syntaxis error.   any idea how workaround for this ?

    mikes0011
    mikes0011Answer
    Brainy
    Oct 6, 2023 8:17 PM UTC

    AFAIK you'll need to configure a basic SELECT statement to use for this smart service.

    The Expression Guru

    6 replies

    mikes0011
    mikes0011Answer
    Brainy
    Oct 6, 2023 8:17 PM UTC

    AFAIK you'll need to configure a basic SELECT statement to use for this smart service.

    The Expression Guru
    Inspiring
    Oct 6, 2023 9:37 PM UTC

    Complicated, is there a way to export more than 50 columns in excel pivoting tabled with something else?

    mikes0011
    Brainy
    Oct 11, 2023 12:33 PM UTC

    If you run the Export DSE to Excel smart service, you should be able to call it once for your first 50 columns, then again for any subsequent set(s) of columns you need.

    The Expression Guru