phpmyAdmin - Executing Queries

Frequently asked questions about mySQL and other databases.

Moderator: Moderators

phpmyAdmin - Executing Queries

Postby DooBDee on Wed Sep 14, 2005 8:18 pm

Hi,

Very short document indeed and shows how to execture SQL queries without using the sql.php on phpBBstyles.com

This document goes for all mySQL / phpmyadmin users.

[list="*"][*]Firstly log into phpmyadmin
[*]Then find your database, this will be shown on the left pane.
[*]Once you have selected your database you should see an SQL Tab at the top of the screen. Click it.
[*]Now enter your SQL query, which may look like this
Code: Select all
ALTER TABLE `phpbb_forums` ADD forum_parent INT NOT NULL DEFAULT '0';
and click "go"
[*]It will now show you results of the query. You will either get an error message or a message / results. If you get an error, read it carefully, you could have made typo. If you are sure you have not made typo, contact the author of the mod.[/list]
DooBDee
Website Ninja
DooBDee.net
User avatar
DooBDee
Moderator
Moderator
 
Posts: 3530
Joined: Tue Mar 01, 2005 6:28 pm
Location: DooBDee.net

Return to Database FAQ

Who is online

Users browsing this forum: No registered users and 1 guest