MySQL Query Test

If you have not already, login to the Control Center at https://www.webcontrolcenter.com/domain.aspx and from the menu item DATABASE select MYSQL and click on MY SQL CONNECTIONS.

This page is used to test your mysql queries against your database without having to write a test page. Enter your query, without dynamic values, in the text area. Click "Test Query". If the query is a success it will return the results in a datagrid on the bottom half of the page. If it errors please look at the top of the page for the error.

Possible Errors
  • Check the query label to see if that was the query you were trying to execute.
  • Dynamic values can cause the query to return either no results or error out completely. Do not use dynamic values.
  • Table does not exist in database.
  • Column does not exist in table. Try selecting all columns (*) first, then narrow the query down.

This page is meant to server as a quick test page, not an absolute results page. It was designed to enter static queries and return the results quickly. How you use it is entirely up to you.

Add Feedback