Friday 26 June 2020

The phpMyAdmin is a third-party tool to manage tables and data inside a database. It is graphical user interface to manage MySQL databases. You can manually create Tables, Import and Export data or edit the values of a row through it.

To access phpMyAdmin, click on the phpMyAdmin link, which can be found under the databases section of cPanel Home.

Web Hosting, Compare Web Hosting, Web Hosting Reviews, Hosting Guides

You will see a dashboard similar to this.

Web Hosting, Compare Web Hosting, Web Hosting Reviews, Hosting Guides

On the left hand pane, there is a list of databases, which can be expended to see the table in each database. On the right hand pane, there is general information of Database server.

Execute an SQL Query


To execute an SQL Query on a database, we will need to perform the following steps −

Step 1 − Select the database from left pane by clicking over the name of the database. Once the database is selected, it will show you the structure of the database.

Step 2 − Click on SQL from top bar to open SQL editor.

Web Hosting, Compare Web Hosting, Web Hosting Reviews, Hosting Guides

Step 3 − Write your query into the SQL editor. You can also enter multiple queries, separated by semicolon (;).

Web Hosting, Compare Web Hosting, Web Hosting Reviews, Hosting Guides

Step 4 − Click Go button to execute the query. If the query is executed successfully, you will get a success message.

0 comments:

Post a Comment

Facebook

Popular Posts

Blog Archive

Total Pageviews