Knowledge Base » phpMyAdmin Series (12)

Category > phpMyAdmin Series (12)

Searching through a database with phpMyAdmin

Thursday, June 14th, 2018

Searching through a database with phpMyAdmin

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

Now let’s learn how to use the search feature.

First, select the database you want to search…

… then click the Search tab.

Let’s search the name field for the name John, using the percent sign (%) before and after our search term, as a wildcard.

This means that phpMyAdmin will search for any data containing the word john, even if it has text before or after it.

When ready, click Go.

That’s it! Our search query returned one result, and the term we searched for is highlighted here.

From here we can edit, copy or delete the data… whatever the reason was that we needed to search for teh data in the first place.

This is the end of the tutorial. You now know how to use the search feature in phpMyAdmin.

Becoming familiar with databases and phpMyAdmin

Thursday, June 14th, 2018

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.

Creating a table in a database with phpMyAdmin

Thursday, June 14th, 2018

Creating a table in a database with phpMyAdmin

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

Now let’s learn how to create a table within a database.

First, select the database in which you want to create a table.

Enter a name for the table.

Enter the number of fields this table is to have, then click Go.

Next, enter the details for each field including a name and field type.

Let’s make this first field the Primary Key, and we’ll click here to make it Auto_Increment.

The remaining fields will be character fields. Be sure the length is set long enough to accomodate the field values.

When finished, click Save.

That’s it! Our new table has been created within our database.

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

Inserting fields into database tables with phpMyAdmin

Thursday, June 14th, 2018

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.

Modifying fields in database tables with phpMyAdmin

Thursday, June 14th, 2018

Modifying fields in database tables with phpMyAdmin

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

Now let’s learn how to modify existing fields within a database table.

First, select the database where the table exists…

… then click the table where field exists that you want to modify.

Click the Structure tab.

Select the field you want to modify, then click Change.

Make the changes you want to make, then click Save.

That’s it! The field has been modified as you can see here.

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

Deleting fields from database tables with phpMyAdmin

Thursday, June 14th, 2018

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.

Copying a database table with phpMyAdmin

Thursday, June 14th, 2018

Copying a database table with phpMyAdmin

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

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

First, select the database where the table exists…

… then click the table you want to copy.

Click the Operations tab.

When copying a table, you can choose to copy the table structure only, the data only, or both.

Copying a table actually creates a new table altogether, so we have to give a name for the new table.

When ready, click Go.

That’s it! A new table has been created, and is a perfect copy of the original. Both table sare listed in the left pane.

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

Renaming database tables with phpMyAdmin

Thursday, June 14th, 2018

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.

Deleting a table from a database with phpMyAdmin

Thursday, June 14th, 2018

Deleting a table from a database with phpMyAdmin

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

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

First, select the database where the table exists.

Select the table by checking its checkbox…

… then click Drop.

Click OK to confirm.

That’s it! The table has been deleted, as well as all fields and data within the table.

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

Exporting databases and tables with phpMyAdmin

Thursday, June 14th, 2018

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.

Importing databases and tables with phpMyAdmin

Thursday, June 14th, 2018

Importing databases and tables with phpMyAdmin

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

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

First, select the database you want to import.

Let’s assume the data in our details table is corrupt, and we want to import a recent backup (or exported copy).

Therefore, let’s first delete the existing details table from the database.

Now let’s import the recently exported copy of our database, which includes the details table.

Click the Import tab…

… then click Choose File and locate the file we want to import.

When ready, click Go.

That’s it! The database has been successfully imported.

We can see here that our details table has been restored.

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

Running SQL queries on a database with phpMyAdmin

Thursday, June 14th, 2018

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.