Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Export base queries to .sql

I have accumulated a number of queries in libreoffice base. The large number of queries is causing the queries window to appear cluttered and thereby I'm don't have overview anymore. For this reason I decided I wanted to store my queries as .sql files and run them through mysql workbench. In that way I can order the queries (.sql files) in folders and keep a better overview.

One way to move the queries to .sql-files is by opening every base query in sql-view and copy-pasting the written commands. However, because that would be a labour intensive, repetitive job, I'm wondering if there is a way to do a batch export of base queries to .sql files.

I'm using Base 6.0.6 on Xubuntu 18.04