Copying a database table with phpMyAdmin

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 […]

Read More

Renaming 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 […]

Read More

Deleting a table from a database with phpMyAdmin

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 […]

Read More

Exporting databases and tables 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 […]

Read More

Importing databases and tables with phpMyAdmin

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 […]

Read More

Running SQL queries on a database with phpMyAdmin

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 […]

Read More

Searching through a database with phpMyAdmin

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 […]

Read More

Becoming familiar with databases and 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 […]

Read More

Creating a table in a database with phpMyAdmin

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 […]

Read More

Inserting fields into database tables with phpMyAdmin

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 […]

Read More