Running SQL queries on a database with phpMyAdmin
Log in to phpMyAdmin
• Click the database on which you wish to run a SQL query.
• Select the query which you wish to drop off. You can get demonstration on deletion of address field using pure SQL commands.
• Click on SQL button and type in the SQL command to delete any field. Click on GO button, when finished.
• You can check the table for the deleted fields. Click SQL button from the table view. You can get the SQL query syntax for visiting the documation.