Glossary Item Box

Squirrelcart v6.1.0

Tools - Database Query

Overview

Squirrelcart contains a tool you can use to perform direct MySQL queries to your database. Making direct queries can be dangerous, so this utility should be used with caution.

 

Launching the Query Tool
  1. Open the control panel
  2. Click the Query menu link
Executing a Query
  1. Launch the Query tool. You will see the query field, which looks like this:

  2. Enter your query in the field and click Submit Query. For this example, we will enter the following query:
    SELECT First_Name, Last_Name, Email_Address FROM Customers;

    Be sure to include a semicolon at the end of the query.

    For this example, you would see one row for each customer below the query field:

 

The query tool will accept any valid MySQL query statement. You can also perform multiple queries at the same time by including more query lines in the query box.

 

 


© 2001-2017 Lighthouse Development. All Rights Reserved.