How to execute SQL queries using phpmyadmin in CPanel server?

A query normally consists of an SQL statement followed by a semicolon. When you issue a query, mysql sends it to the server for execution and displays the results, then prints another mysql> prompt to indicate that it is ready for another query. mysql displays query output in tabular form (rows and columns).

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.

Be careful when executing SQL queries , while using destructive commands (such as DROP) . Before making any significant changes kindly take the backup for the safety purpose.

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 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.