How To

How to Run an SQL Database Query

Member
By BlueOx
User-Submitted Article
(1 Ratings)
Run an SQL Database Query
Run an SQL Database Query

Running an SQL database query is one of the most basic functions of database management. Anyone who operates a database driven website should learn how to run an SQL database query. These queries are useful for changing large blocks of information, adding new tables or fields, exporting or importing data, or most any other function that can be performed on your database. Queries offer an easier, more streamlined option for performing these routine tasks. Here is how to run an SQL database query.

Difficulty: Moderately Easy
Instructions
  1. Step 1

    Log into the control panel for your web host and look for the link to phpMyAdmin. This will take you to the administration area of your databases. Click this link.

  2. Step 2

    Know that when you enter phpMyAdmin, you will notice that the left side of the screen lists the SQL databases that are on your server. Click on the name of the database you will be running queries on. This will take you to the main administration screen for that database.

  3. Step 3

    Consider that after you enter the administration area for the SQL database that you will be editing, the next step is to open the query window. You do this simply by clicking on the SQL link for the database. This link will be found in two locations. First, look on the left column of the screen, under where it says "phpMyAdmin". There will be a row of 5 icons, with the middle icon being a window that says "SQL". Or, in the main window, the 2nd tab at the top of the screen will say "SQL". Clicking on either of these links will take you to an area to run an SQL database query.

  4. Step 4

    Know that on the SQL database query screen, simply type your database query into the box and click the "Go" button. That's all there is to it. Your database query will be ran by the database and any changes will be instantaneous.

Tips & Warnings
  • If you do not know what you are doing, you can actually do harm to your database with an SQL database query. If you are unsure, it is always a good idea to make a backup copy of the database before running your queries.
Resources

Post a Comment

Post a Comment
  • Have you done this? Click here to let us know.
I Did This

Related Ads

Computers
Alexia Petrakos,

Meet Alexia Petrakos eHow's Computers Expert.

Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US

eHow Computers
eHow_eHow Technology and Electronics