Skip to main content
V
vladimirv0001
October 6, 2023
Solved

SQL to Excel

  • October 6, 2023
  • 6 replies
  • 0 views

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 ?

    Best answer by mikes0011

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

    6 replies

    mikes0011
    mikes0011Answer
    Brainy
    October 6, 2023

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

      V
      vladimirv0001Author
      October 6, 2023

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

      mikes0011
      mikes0011
      Brainy
      October 11, 2023

      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.

      Terms & ConditionsAccessibility statement