Running SQL queries on a database with phpMyAdmin Print

  • 0

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.


Was this answer helpful?

« Back