Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Automation Of Sql Query

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Automation Of Sql Query

Tagged: ,

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • August 20, 2014 at 9:23 am #35020
      peterlaursen
      Participant

      The is an “SQL Scheduler and Reporting Tool” (in the ‘powertools’ menu), but it will deliver query results as HTML-formatted mail. With the same tool you may schedule a SELECT INTO OUTFILE -query generating a CSV file.  But note that  SELECT INTO OUTFILE in MySQL has no LOCAL option so the file will be saved on the server machine. Refer MySQL documentaton http://dev.mysql.com/doc/refman/5.5/en/select-into.html.

       

      We have a request already for client-side generation fof CSV (and other file formats) from this tool in our issuetracker at https://code.google.com/p/sqlyog/issues/detail?id=1696.  But it is currently not possible and it is also not planned for near future.

    • November 27, 2015 at 7:46 pm #35021
      Stacy Martin
      Member

      I, too, wish sqlyog had this functionality.

    • January 29, 2016 at 10:10 pm #35022
      zenggggg
      Member

      you can do it by excel macro VBA, and schedule time in windows task scheduler. your sql code will be inside your vba code. once macro run, sql runs and auto populate the data on excel. 

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.