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.

Was this answer helpful?

 Print this Article

Also Read

Deleting Fields from Database Tables with phpMyAdmin

To delete fields from database tables in phpMyAdmin, first login to phpMyAdmin and then follow...

Exporting Databases and Tables with phpMyAdmin

To export databases and tables in phpMyAdmin, first login to phpMyAdmin and then follow this...

Copying a Database Table with phpMyAdmin

To copy a database table in phpMyAdmin, first login to phpMyAdmin and then follow this guide. 1....

Importing Databases and Tables with phpMyAdmin

To import databases and tables in phpMyAdmin, first login to phpMyAdmin and then follow this...

Renaming Database Tables with phpMyAdmin

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