Knowledgebase

How To Run SQL Queries In phpMYAdmin

1. Log in to your cPanel.

2. Navigate to your control panel and click the phpMyAdmin icon.

3. In the phpMyAdmin homepage, navigate to the area where you wish to run your SQL query.

a. The phpMyAdmin home page if you want the query to apply to the whole server or hosting account.

b. The database you want to run queries against.

c. The table you want to run queries against.

4. Click on the SQL tab.

SQL tab

5. Type in your SQL query.

Sample Query

6. Click on Go.

7. The new table, thisismynewtable, is now created under the database example_db1.

Sample new database

 

 
 
 
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is a cache

A cache is a reserved storage location that keeps data temporarily to help websites, browsers, and apps load faster. This makes quick data retrieval easy, which in turn helps devices run...

How Do I Take Screenshots on Windows?

Sometimes, when contacting our Customer Support, you may be asked for a screenshot of whatever problems you may be facing. In Windows, there are several ways to take a screenshot: 1. Using the...

How To Create Database User

1. Log in to cPanel. 2. Go to Databases section, then click MySQL Databases. 3. Click the Jump to MySQL Users link at the top-right corner of the page. 4. Under Add New User, enter a username...

How To Create MySQL Database

1. Log in to cPanel. 2. Look for the Databases section, then click MySQL Databases. 3. In the New Database field, type your database name. 4. Click Create Database. 5. Click Go Back.

How To Modify the php.ini file

Sometimes, you may need to modify some default PHP settings, and below we've outlined those steps. 1. Log in to cPanel. 2. Go to the Software section and click on the MultiPHP INI Editor icon....