Knowledge Base
MilesWeb / How-Tos

How can I run SQL queries in phpMyAdmin?

Approx. read time : 2 min

The article will guide you on how to run SQL queries in phpMyAdmin.

SQL queries are executed in commands that are issued to the MySQL server to perform various functions. SQL is mostly used by developers to make changes to your database by using appropriate commands.

To execute MySQL query for a database, open the database with phpMyAdmin and then click on the SQL tab.

Perform the following steps to run SQL queries in phpMyAdmin :

1) Login to cPanel.

cPanel MyAdmin

2) Go to Software and then click on phpMyAdmin.

3) Navigate to the area, where your SQL query appears. Select the database or tables for which you want to run queries.

SQL screen

4) Click the SQL tab.

5) Now type your SQL query here.

6) Click on Go. Your query will get executed.

SQL query execute

The result from a query that we executed is :

SQL query results

Once the SQL query has fired and executed, the command screen confirms that your SQL query has been executed successfully.

Also Read :

1) How can I connect to SQLite using PHP?

2) How To Create MySQL Tables In phpMyAdmin?

3) How to search MySQL tables in phpMyAdmin?

Sonam Wagh
With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.
Need help? We’re always here for you.