Running SQL Queries on a Database with phpMyAdmin


  1. This tutorial assumes you've already logged in to phpMyAdmin. Now let's learn how to run SQL queries on a database.


  2. Click the database table you wish to run a SQL query on.


  3. Click the SQL button here.


  4. Then type your SQL command. Click Go when finished.


  5. In this case, we’re going to delete the address field from the details table using the command:

    ALTER TABLE details DROP COLUMN address;

  6. That's it! The SQL command is executed when you click Go. Let's go take a look.
  7. The address field is no longer in our details table.


  8. You can also click the SQL button directly from the table view. Doing so presents a SQL query window that is partially filled in.



Be Sociable, Share!
    Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support