To modify or delete an existing table, select the database that contains it, by clicking on the database name in the left column.
A listing of all the tables in the database will appear, with several options under the Actions heading.
If we click browse, we can browse through all the data in our table. Since we have no data, an "empty result set" message appears at the top.
It is not a good practice to press the back button in PhpMyAdmin. To navigate back to the table administration area, click the database name again. This takes you back to the beginning.
To modify the structure of our database click Structure.
A listing of all our columns appears.
We can delete a column by clicking the Drop button.
We can change the structure of a column by clicking the Change button.
Remember to always press the "Save" button when making changes.
We can run a search in our database by pressing the Search button.
On the page that loads, you can input the search text in the Value field. Make sure to select the appropriate search operator.
For example, if you are looking for a first name that matches the name "Ted Smith", choose the LIKE operator and enter "Ted Smith" in the Value field.
If you are looking for an id that matches a specific value, select the equals operator and enter the value in the adjacent text field.
We can insert data into our table, by clicking the Insert button.
To insert a record, enter the data into the corresponding fields and click "Go". You don't need to insert anything in the id field, because that value is automatically assigned. Remember it's an auto incrementing number (our primary key).
To see the new record, click the "Browse" button.
We can see our table now has one record.
The id was assigned a value of one because it's our first record. The date was automatically time stamped in the date column.
The last two options are Empty and Drop. The Empty button will empty all the data in the table. The Drop button will permanently delete the entire table. So be careful with these options.