phpMyAdmin Series (12)

Running SQL queries on a database with phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

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

First, select the database you want to run a query on…

As demonstrated in another video, you can delete (or drop) a field from a table by selecting it…

… then clicking the Drop icon.

In this video however, we’re going to demonstrate how to delete this field using pure SQL commands.

Click the database name, then click the SQL tab.

Type the SQL command to delete the address field, then click Go.

That’s it! The SQL command has been executed successfully.

The address field is no longer in our database table.

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

Doing so presents an SQL query window that is partially filled in.

For more information on learning about SQL query syntax, visit the MySQL documentation page.

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

Becoming familiar with databases and phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

Now let’s familiarize ourselves with databases and phpMyAdmin.

phpMyAdmin allows us to have complete access to the MySQL databases in our account.

The databases are listed here in the left pane.

Databases consist of one or more tables, and it is within these tables that database information (or data) is stored.

This particular database has one table, and it’s called details.

When we click on a database name in the left pane, we can see more information about the tables within the database in the right pane.

We can browse a table to see the individual records…

… we can see the structure of a table and perform certain actions…

… we can search through a table for specific keywords…

… we can insert new rows (or fields) into a table…

… we can delete the contents of a table…

… or we can delete (or drop) an entire table altogether.

We can alternatively click the Structure tab to view the database structure…

… click the SQL tab if we want to enter direct queries to the database…

… click the Search tab to perform a search…

… Import or export databases or tables…

… and several other operations.

Now let’s take a closer look at the details table. Click the table name in the left pane, then click the Structure tab.

The structure of a table lists all teh table’s fields, along with the type of fields and other information.

We can also see which field within the table is the Primary Key field.

If you ever need additional help, you can access either phpMyAdmin or MySQL documention by clicking the appropriate help icon here.

Click the Home icon to return to the home page of your phpMyAdmin.

This is the end of the tutorial. You should now be more familiar with databases, and how to use phpMyAdmin to access them.

Inserting fields into database tables with phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

Now let’s learn how to insert fields in a database table.

First, select the database where the table exists…

… then click the table where you want to insert the new field.

Click the Structure tab.

Choose how many fields to add, and where in the table they should be added.

Click Go.

Enter the name, type and length of the new field, then click Save.

That’s it! Our table now has a new field in it, as you can see here.

This is the end of the tutorial. You now know how to insert new fields into database tables with phpMyAdmin.

Deleting fields from database tables with phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

Now let’s learn how to delete fields from a database table.

First, select the database where the table exists…

… then click the table from which you want to remove a field.

Click the Structure tab.

Select the field you want to delete, then click Drop.

Click OK to confirm.

That’s it! The field has been removed from our table.

This is the end of the tutorial. You now know how to delete fields from database tables with phpMyAdmin.

Renaming database tables with phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

Now let’s learn how to rename a database table.

First, select the database where the table exists…

… then click the table you want to rename.

Click the Operations tab.

Under Table Options, in the Rename table to section, enter a new name for the table, then click Go.

That’s it! The table has been renamed, as can be seen here in the left pane.

This is the end of the tutorial. You now know how to rename a database table with phpMyAdmin.

Exporting databases and tables with phpMyAdmin

This video assumes you’ve already logged in to phpMyAdmin.

Now let’s learn how to export databases and tables.

First, select the database you want to export…

… then click the Export tab.

If you want to export the entire database including all tables within, leave the Quick export method selected.

In this case we want to export the database in SQL format so we can easily import it later. This is a good way to back up your database.

When ready, click the Go button.

A complete copy of your database will be downloaded to your computer.

If you want more options before exporting, click the Custom export method.

Here we can select which tables to include…

… and we can rename our exported file .

There are many other options we could choose, but in most cases we’ll just want to keep the defaults.

When ready, click Go.

That’s it! A copy of your database will be downloaded to your computer, as per the options you chose.

This is the end of the tutorial. You now know how to export databases and tables with phpMyAdmin.