phpMyAdmin - SQL

phpMyAdmin provides a SQL console under SQL Tab. Its context varies as per the selection. If no database is selected, then SQL console opens in localhost context otherwise in relevant database context. In given example, we've selected a database TutorialsPoint. Now switching to SQL shows the following screen.

SQL Console

Now let's run a simple query to see SQL Tab in action. SQL interface will keep suggesting keywords while user types. You can press Ctrl+Space to open the relevant suggestion as well.

SQL Suggestions

Now click on Go Button and phpMyAdmin will run the query and show the result as shown below −

SQL Result
Advertisements