This site utilizes JavaScript to function correctly. Looks like it's disabled on your browser. Please enable it for your best experience.

For instructions on enabling JavaScript, click here

Skip to main content
Search

Just Host Web Hosting Help

How To Run SQL Queries in PHPMyAdmin

How to run SQL queries in phpMyAdmin

This tutorial demonstrates how to run SQL queries in phpMyAdmin.

SQL queries are commands that you issue to the MySQL server to tell it to perform various functions. Designed for advanced users, this allows you to quickly make changes to your database simply by issuing the appropriate commands.

This tutorial shows you where to execute SQL queries, but not what queries to execute. The exact SQL queries you will execute will depend on what you want to do.

Be careful when executing SQL queries, because it will do whatever you tell it to do (and not necessarily what you want it to do). Always double check any destructive commands (such as DROP) to make sure it is acting upon the items you intend it to act upon. If you are making significant changes, it is recommended that you make a backup before you begin.

Queries are Context Sensitive

The SQL tab appears above all pages inside of phpMyAdmin.  This tab is context sensitive, which means that depending on what you're looking at, the target of your SQL queries might be different.

If you are on the home page of phpMyAdmin and do not have any databases selected, if you click the SQL tab, any queries you run will apply to the overall server (or hosting account if on shared hosting).

If you select a database, any queries run by clicking on the SQL tab will apply to that database.

If you select a table within a database, any queries run by clicking on the SQL tab will apply to that table.

Summary of Steps

Begin by accessing phpMyAdmin via cPanel.

  1. Navigate to the area your SQL query will apply to.
    • The phpMyAdmin home page if you want the query to apply to the entire server or hosting account.
    • The database you want to run queries against.
    • The table you want to run queries against.
  2. Click the SQL tab.
  3. Type in your SQL query.
  4. Click the Go to execute the query.

Your SQL query will be executed and the actions you requested will be performed.

Knowledgebase Article 191,944 views bookmark
share
Share or save this via:
tags: databases mysql phpmyadmin


Was this resource helpful?
Helpful Unhelpful


Did this resolve your issue?
Solved Unsolved


Please add any other comments or suggestions about this content:





Recommended Help Content

Optimizing MySQL: Queries and Indexes Article 4 of 4
Optimizing MySQL: Queries and Indexes Article 4 of 4 Courtesy of:Ian Gilfillan Most systems need to be highly optimized for selects - take a news site which performs millions of queries per day, but w
Knowledgebase Article 215,160 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

Optimizing MySQL: Queries and Indexes Article 1 of 4
Optimizing MySQL: Queries and Indexes Article 1 of 4 Courtesy of: Ian Gilfillan Badly defined or non-existent indexes are one of the primary reasons for poor performance, understanding and then fixing
Knowledgebase Article 220,757 views tags: indexes mysql optimize optimizing queries query

Optimizing MySQL: Queries and Indexes Article 2 of 4
Optimizing MySQL: Queries and Indexes Article 2 of 4 Courtesy of: Ian Gilfillan Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table w
Knowledgebase Article 187,735 views tags: indexes mysql optimize optimizing queries query

Related Help Content

Modifying table columns - phpMyAdmin
A step by step guide on how to manipulate data in your mySQL tables using phpMyAdmin
Knowledgebase Article 199,414 views tags: databases mysql phpmyadmin

Optimizing MySQL: Queries and Indexes Article 3 of 4
Optimizing MySQL: Queries and Indexes Article 3 of 4 Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example o
Knowledgebase Article 221,077 views tags: cpu exceeded index indexes mysql optimize optimizing queries query

How To Copy A Database Using PHPMyAdmin
A guide to duplicating a MySQL database using phpMyAdmin
Knowledgebase Article 243,066 views tags: databases mysql phpmyadmin

Managing Your DB Using phpmyadmin
A repository of information on how you can manage your database by using the phpMyAdmin interface.
Knowledgebase Article 375,804 views tags: commands database mysql phpmyadmin

Dropping columns from a database table using PhpMyAdmin
A tutorial on how to perminately delete columns from your mySQL database using phpMyAdmin
Knowledgebase Article 188,787 views tags: Plesk cpanel databases mysql phpmyadmin

How To Rename Database Tables in PHPMyAdmin
This article will show you how to rename a database table in phpMyAdmin.
Knowledgebase Article 322,748 views tags: databases mysql phpmyadmin

Searching a database in PhpMyAdmin
Step by step directions on how you can search your database using phpMyAdmin
Knowledgebase Article 185,216 views tags: Plesk cpanel databases mysql phpmyadmin

Adding a column to a db table in phpMyAdmin
Instructions on adding a column to your database in phpMyAdmin
Knowledgebase Article 207,004 views tags: databases mysql phpmyadmin

*Promotional pricing is for the first term only and regular rates apply upon renewal. 30-Day Money-Back Guarantee does not extend to domain names.

** Google ad credits are only available to customers in the United States, Canada, and the United Kingdom at this time.

¹ VAT (Value Added Tax) is not included in our advertised price and will be charged separately and itemized on invoices and billing information. Standard VAT rates based on EU Member State regulations may apply. Learn more.