Querying MySQL databases using phpMyAdmin

Query a MySQL database

To query a MySQL database:

1. Log into the Manage MySQL tool.
2. In the Current MySQL Databases section, click a login name for a database to log into phpMyAdmin.
3. To build your query, specify your criteria using the fields below. When you make a change, click the Update Query button so that your options will take effect.
   • Field: Select the table.fields that you want to query. Tables and fields are displayed with the name of the table, a period, and then the name of the field.
   • Sort: Select whether you want the results to be sorted in Descending order (top to bottom) or Ascending order (bottom to top).
   • Show: Select this checkbox if you are selecting fields and want to have them displayed.
   • Criteria: Enter your search criteria. For example, if you entered '3' without the double quotes, your query would basically read 'find all of the records where the field I selected is greater than 3'.
   • And/Or: If you want to enter another search criteria, select whether you want the selected records to match both or either criteria then enter the string into the text box. You can select 'And' or 'Or' for two different search criteria within the same field and also when searching more than one field at a time.
   • Ins & Del Checkboxes: Select the Ins checkbox next to a criteria row or under a field column to add another option. Select the Del checkbox next to a criteria row or under a field column to remove an option.
   • Add/Delete Criteria Row: Select the number of criteria rows to add (positive number) or delete (negative number). This option is similar to the Ins and Del checkboxes for the criteria rows, except that you are able to add or remove more than one option at a time.
   • Add/Delete Field Columns Select the number of field columns to add (positive number) or delete (negative number)This is similar to the Ins and Del checkboxes for the field columns, except that you are able to add or remove more than one option at a time.
   • Use Tables: Select the tables to query. Selected tables will affect the values in the Field field.

1. Click Update Query as you make changes. The query will be written out in the SQL query on database field.
2. Click Submit Query to run the query. The page displays the query code and results.

Running SQL queries on a MySQL database with phpMyAdmin

This tutorial teaches how to run SQL queries on a MySQL database with phpMyAdmin.

MySQL connections and query limits

A query limit is the maximum number of database actions performed in one hour by a specific user. Note that a user can have multiple concurrent MySQL connections, in which case the sum of all database actions for all connections cannot exceed the given limit.

• The maximum number of concurrent MySQL connections per user is 20.
• The maximum number of database queries per user is 75,000/hr.