Running SQL Queries on a Database with phpMyAdmin

To run SQL queries on a database in phpMyAdmin, first login to phpMyAdmin and then follow this guide.

1. Click the database on the left hand side that you wish to run the SQL query on.

2. Click the 'SQL' icon and enter your SQL query in the text box.

3. An example would be to delete a field from a table using SQL, enter the following query.

4. ALTER TABLE 'enter the name of your table containing the field here' DROP 'enter the field name here'

Note: Remember to include the ' in the query

5. Click 'Go' and 'OK' to execute the SQL command.

6. Click the database table on the left hand side and you will see the field you nominated has been deleted.

7. You can also click the 'SQL' icon in the table view which will give you a partially completed SQL query.

Note: For further help with phpMyAdmin click the 'Question Mark' icon on the left hand side.

Note: For further help with SQL click the 'SQL' icon on the left hand side.

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Searching through a Database with phpMyAdmin

To search through a database in phpMyAdmin, first login to phpMyAdmin and then follow this...

Creating Tables in a Database with phpMyAdmin

To create tables in a database in phpMyAdmin, first login to phpMyAdmin and then follow this...

Inserting Fields into Database Tables with phpMyAdmin

To insert fields into database tables in phpMyAdmin, first login to phpMyAdmin and then follow...

Renaming Database Tables with phpMyAdmin

To rename database tables in phpMyAdmin, first login to phpMyAdmin and then follow this guide. 1....

Becoming Familiar with Databases in phpMyAdmin

To familiarise yourself with databases in phpMyAdmin, first login to phpMyAdmin and then follow...