phpMyAdmin Resources
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to use the Search feature Click the database you wish to search here Then click the Search button Enter words or values to search for in the database. There are several options you can use to refine your search. This database only
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to rename database tables Click the database table you wish to rename Then click the Operations button Enter a new name for the table here Then click Go That’s it! The information table has been renamed infotable, and is listed here This
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
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to modify fields in database tables Select the details table here Let’s modify the address field Click the Change icon Make the changes you want, then click Save That’s it! We’ve successfully changed the name of the address field to city This
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to insert fields into database tables Select the details table here In this case, let’s choose to add an address field AFTER the name field Click Save when finished That’s it! Our details table now has a new address field This is
This tutorial assumes you’ve already logged in to phpMyAdmin Now let’s learn how to import a database Click the database you wish to import here Let’s assume the data in our details table is corrupt, and we want to import a saved (exported) copy of the data. Therefore, let’s first delete the existing details table
This tutorial and video will discuss how to manage and use databases in phpMyAdmin This tutorial assumes you’ve already logged in to phpMyAdmin. From this phpMyAdmin screen, we have access directly to the database demo1234_members, listed here. A database consists of one or more tables, and it is in the tables that database information is
This tutorial will show you how to export databases with phpMyAdmin Click the database you wish to export here Then click the Export button In this case, we want to export the entire database in SQL format, so we can easily import it later. This is a good way to backup your database Be sure
This tutorial will show you the steps for deleting tables from a database with phpMyAdmin Select the table you wish to delete here You can delete individual fields from this table by selecting them here then clicking the delete icon here However, in this tutorial we’re going to demonstrate how to delete the entire table
This tutorial will show you the steps for deleting fields from database tables with phpMyAdmin Now let’s learn how to delete fields from database tables Select the details table here Let’s delete the city field Click the Delete (or Drop) icon Click Yes to confirm That’s it! We’ve successfully deleted the city field from our
This tutorial will show you the steps for creating a database table with phpMyAdmin Select thedemo1234_members database here Enter a Name for our new table Then enter the number of fields this new table is to have. Click Go Now enter the details of each field within the new table We also want this first
This tutorial will show you how to copy a database table with phpMyAdmin Click the database table you wish to copy Then click the Operations button When copying a table, you can choose to copy the table structure only, the data only, or both. Enter a name for the new table here, then click Go
