Scheduled Export As Html Or Excel Xml

[br8kwall]

I did a little poking around here and didn't think I saw this ability outside of feature requests. So hopefully someone can prove me wrong.

I need to export a large result set (from query) into HTML (though the client thinks they want Excel). The output is from a forum so the records are large and are loaded with newlines and bbcode tags. Which is to say that even carefully escaped CSV -> Excel looks terrible with columns and rows getting mis-aligned.

The client wants a daily dump that they can download from our web server.

The output from “Tools/Export all rows of table/data result as…” is very nice and seems to handle these nicely. I think what I want to do is run this on a daily, scheduled basis. Can I do this?

I wish mysql had a SELECT … INTO HTML option..

[navyashree.r]

Hi,

Thank you for valuable request.

We need to discuss with other colleagues regarding this feature. Meantime, we have added your request in our issue tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1226

We will update about this once done with the other features which is already planned for the next 3-4 months.

Regards,

Navya

[Author]

Posts