How to run SQL queries on a database using phpMyAdmin:
Step 1: Access phpMyAdmin
- Log in to your phpMyAdmin account.
Step 2: Navigate to the Database and Table
- On the main phpMyAdmin screen, the left side is blue and lists your databases.
- Click on the database that contains the table on which you want to run an SQL query.
- Below the database name, you'll see a list of tables within that database. Click on the specific table you want to work with.
Step 3: Open Table Details
- Clicking on the table will open the table details in the right-hand window.
Step 4: Run an SQL Query
- To run an SQL query, go to the right-hand side and click on the name of the database (not the table). This will display the details of the entire database in the right-hand window.
Step 5: Access SQL Query Box
- At the top of the right-hand window, click the "SQL" button. This will open a box titled "Run SQL query/queries on database."
Step 6: Enter the SQL Command
- In the SQL query box, you will need to type the SQL command to perform your desired action.
- Replace `table_name` with the name of your table and `field_name` with the name of the field you want to delete.
Step 7: Execute the Query
- After typing your SQL command, click the "Go" button to execute the query.
Step 8: Confirm the Action
- A pop-up confirmation window will appear to verify if you really want to perform the SQL action. Click "OK" to proceed.
Step 9: Verify Successful Query
- The command screen will then confirm that your SQL query has been successful. You've now executed an SQL query on the database.
Step 10: Additional Resources
- For more information about SQL syntax and commands, you can visit the MySQL documentation by clicking on the icon under the phpMyAdmin name that features the red SQL icon.
Â
