Steps to Query a MySQL Database
1. Log into the Manage MySQL tool.
2. Go to the Current MySQL Databases section and click on a login name for a database to log into phpMyAdmin.
3. Specify your criteria to build your query using the fields below. After making a change, click the Update Query button for your options to take effect.
- Field: Select the table.fields for the query you want. Tables and fields come with the name of the table, a period, and then the name of the field.
- Sort: Choose the order in which you want the results to be sorted either Descending order (top to bottom) or Ascending order (bottom to top).
- Show: Tick this checkbox if you are selecting fields and want to have them displayed.
- Criteria: Specify your search criteria. For instance, if you entered ‘3’ without the double quotes, your query would basically read ‘search all of the records where the field I selected is greater than 3’.
- And/Or: For entering other search criteria, select whether you want the chosen records to match both or either criteria then specify the string into the text box. You can select ‘And’ or ‘Or’ for two different search criteria within the same field and also, while searching more than one field at a time.
- Ins & Del Checkboxes: Tick the Ins checkbox next to a criteria row or under a field column to add another option. Choose the Del checkbox next to a criteria row or under a field column to remove an option.
- Add/Delete Criteria Row: Choose the number of criteria rows to add (positive number) or delete (negative number). You will find this option same as the Ins and Del checkboxes for the criteria rows. Except that you can add or remove more than one option at a time.
- Add/Delete Field Columns: Choose the number of field columns to add (positive number) or delete (negative number). You will find this option same as the Ins and Del checkboxes for the field columns. Except that you can add or remove more than one option at a time.
- Use Tables: Choose the tables to query. The tables that are selected will affect the values in the Field field.
4. Click on Update Query after making changes. You will find the query written out in the SQL query on database field.
5. To run the query, click on Submit Query. The page displays the query code and results.
Steps to Run SQL Queries on a MySQL Database with phpMyAdmin
In this tutorial, you will learn how to run SQL queries on a MySQL database with phpMyAdmin.
MySQL Connections and Query Limits
A query limit refers to the maximum number of database actions performed in one hour by a specific user.
Remember that a user can have multiple concurrent MySQL connections, in case the sum of all database actions for all connections can’t exceed the given limit.
- The highest number of concurrent MySQL connections per user is 10.
- The highest number of database queries per user is 75,000/hr.