Home >Daily Programming >Mysql Knowledge >How to use phpmyadmin to add, delete, modify and check databases and data tables? (Pictures + Video)
This article will introduce to you the relevant summary in phpmyadmin usage tutorial, which is to use phpmyadmin to perform some basic operations such as adding, deleting, modifying and checking the database and data tables.
phpmyadmin is a commonly used database manager. Newbies who want to install phpmyadmin can refer to this article [phpMyAdmin latest download and installation tutorial]. Below we will give you a detailed introduction through specific pictures and texts, phpmyadmin's relevant knowledge points for operating database data tables.
1. phpmyadmin creates a new database
Open the phpmyadmin interface, click on the database column, create a new database named mymysql, and select the character set.
2. Rename the database
Click on the operation interface and rename the mymysql data to myhome.
3. Delete database and copy database
In the operation interface, you can choose to delete the database or copy it When copying a database, you can choose to copy only structure, structure and data, or data only.
4. Create a new data table
Open the myhome database and create a new data table named admin.
#Then add the corresponding fields in the data table.
#5. Modify the data table Medium field type
In the structure, select the field to modify.
6. Move the data table
Move the data table to a specified location in the operation interface inside the database.
Select the data table to be deleted or copied, and click to open the operation interface. Perform operations such as deleting, clearing, and copying data tables.
:After deleting and clearing the database or data table, it cannot be recovered, so please operate with caution. Then the above is an introduction to the
phpmyadmin usage tutorialon creating, deleting, renaming and other related operations of databases and data tables! For more related tutorials, please visit php Chinese website mysql video tutorial, welcome to refer to and learn!
The above is the detailed content of How to use phpmyadmin to add, delete, modify and check databases and data tables? (Pictures + Video). For more information, please follow other related articles on the PHP Chinese website!