How to Run SQL Queries with WP-DB Manager
The final part of the guide to the WP-DB Manager WordPress Plugin will show you how to run an SQL (Structured Query Language) query, which are specific instructions that run against the database and help it format tables, remove or add data, and execute stored procedures.
Step 1) The first step is to head to ‘Database’ on your Dashboard and then choose ‘Run SQL Query’ from the dropdown. This will take you to the query page, where you can add multiple queries using INSERT, UPDATE, DELETE, CREATE and ALTER statements to give orders as to the kind of queries you wish to make.
Step 2) Underneath the query box, there are three instructions that will help you to run an effective query. Read these before you click ‘Run’ underneath the query box.
Step 3) Once you have completed your query box (with a new line for each query if you have more than one), click the ‘Run’ button at the bottom of the page.