The Query Builder allows plugin users to execute any SQL command (DCL, DDL and DML) from the WordPress dashboard, as long as the user has the necessary credentials. The tool is available for admin users only and restricts access to WordPress tables. Multiple queries...
SQL
Tutorials
Short video tutorial to demonstrate the Query Builder.Multi SQL commands now supported!
Visual Query Builder
The Visual Query Builder (requires a premium license) helps plugin users with no or little SQL knowledge to write SQL queries using a intuitive graphical user interface. Click button "Visual Query Builder" to start the graphical user interface (see image below - click...
Writing queries
You must be an admin user to use the Query BuilderWrite and execute SQL queriesThe Query Builder starts with an empty tab. SQL commands are written in the editor below the tab. Select a database, enter a query in the editor and press the Execute button.Multiple SQL...
Data exchange
A tab in the Query Builder is related to a specific database. Although the Query Builder supports the USE database command to switch to another database, it is not possible to have two connection at the same time. This makes it impossible to copy table data from one...
Stored procedures
Write / on an empty line to enter a stored procedure, stored function, or database trigger.ExamplePresuming table dept is available in the selected database, the code above will show three tabs: Result of the drop procedure command Result of the create procedure...
Database triggers
The Query Builder allows you to write your own database triggers. Here is a simple example of a database trigger that prevents updates on table dept.When the user tries to update a row in table dept with this trigger enabled, the trigger prevents the update and...
Scheduled queries
It is possible to use MySQL events to execute queries at regular intervals. Conceptually, this is similar to the Unix crontab and the Windows Task Scheduler. The example below truncates my demo table and adds five rows every 60 seconds.Notes The event scheduler needs...
Recent Comments