Running SQL queries on a database with phpMyAdmin

Back to search

This tutorial assumes you've already logged in to phpMyAdmin

Now let's learn how to run SQL queries on a database

Click the database table you wish to run a SQL query on

As demonstrated in another tutorial, you can delete (or drop) a field from a table by selecting it here then clicking the drop icon here

In this tutorial however, let's demonstrate how to delete this address field using pure SQL commands

Click the SQL button here

Then type the SQL command to delete the address field from the details table. Click Go when finished

That's it! the SQL command has been executed. Let's go take a look

The address field is no longer in our details table

You can also click the SQL button directly from the table view (instead of from the database view which is what we did).....

..... doing so presents a SQL query window that is partially filled in

For more information on learning about SQL query syntax, visit the MySQL documentation available here

This is the end of the tutorial. You now know how to run SQL queries on a database using phpMyAdmin

Also Read

How to install Zen Cart from Softaculous
1 Scroll down until you find Zen Cart in the menu on the left. 2 Click Zen Cart. This Overview...
Configuring your website in FileZilla
This tutorial assumes you already have FileZilla running on your computer but have not connected...
How to create a subdomain in cPanel
This demo assumes you've already logged in to cPanel Now let's learn how to create a subdomain...
Configuring your website in WinSCP
This tutorial assumes you already have WinSCP running on your computer, but have not...