Knowledge Base

Executing SQL Queries in phpMyAdmin
Article ID: 121
Written By: morpheus2matrix
Written On: Thu May 03, 2012 1:48 pm
Description: Get the steps to executing SQL queries for MODs in phpMyAdmin
link to this article on phpbb.com: Select All
[kb=executing-sql-queries-in-phpmyadmin]Executing SQL Queries in phpMyAdmin[/kb]
link to this article on your own board: Select All
[url=http://www.phpbb.com/kb/article/executing-sql-queries-in-phpmyadmin/]Knowledge Base - Executing SQL Queries in phpMyAdmin[/url]

This KB article is a quick 'how to', for a more detailed set of instructions see this topic viewtopic.php?f=16&t=588696

1. Go into phpMyAdmin in your web browser and enter your login and password : you should see a screen like this :
Image

2. Now, find your database on the left part of the screen :
Image

3. You should see something like this :
Top of the screen :
Image

4. Look for the SQL tab and click it. Once you are on this page, copy/paste the SQL query to run into the box :
Image

5. Click on "Go" (or Execute) :
Image

6. Now, you should see a page like this :
Image

7. If you get a message error, like this :
Image

Just read the error message and correct the sql query and try it again.



If all has gone well you have then successfully executed a SQL query using phpMyAdmin.