Executing SQL Queries in phpMyAdmin |
Description: Get the steps to executing SQL queries for MODs in phpMyAdmin |
Author: morpheus2matrix |
Date: Wed Oct 29, 2003 2:18 am |
Type: Tutorial |
Keywords: phpmyadmin, MODs, sql, executing, installing |
Category: MODifications |
|
Ok, this tutorial will try to explain how to use phpmyadmin to add a table to your database or to modify your database.
I've use phpmyadmin version 2.6.1 for this but it's the very much the same with other versions : so let's go
- Go into phpMyAdmin in your web browser and enter your login and password : you should see a screen like this :
http://www.adamreyher.com/pub/phpbb/kbarticle151/1.gif
- Now, find your database on the left part of the screen :
http://www.adamreyher.com/pub/phpbb/kbarticle151/2.gif
- You should see something like this :
Top of the screen :
http://www.adamreyher.com/pub/phpbb/kbarticle151/3.gif
- Look for the SQL tab and click it. Once you are on this page, copy/paste the SQL query to run into the box :
http://www.adamreyher.com/pub/phpbb/kbarticle151/4.gif
- Click on "Go" (or Execute) :
http://www.adamreyher.com/pub/phpbb/kbarticle151/5.gif
- Now, you should see a page like this :
http://www.adamreyher.com/pub/phpbb/kbarticle151/6.gif
- If you get a message error, like this :
http://www.adamreyher.com/pub/phpbb/kbarticle151/7.gif
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.
Edited by wGEric
Edited by AdamR to fix images |
|
|