Detailed graphic and text explanation of database addition, deletion and modification operations (phpMyAdmin usage tutorial 1)

Detailed graphic and text explanation of database addition, deletion and modification operations (phpMyAdmin usage tutorial 1)

Whether it is a Windows operating system or a Linux operating system, phpMyAdmin is graphical The management tools are all used in the same way.

In the previous article "Introduction to phpMyAdmin" we mainly introduced the installation and use of phpMyAdmin, so our article mainly explains the visual interface of the phpMyAdmin graphical management tool Operating database~!

Operation database

Enter: localhost/phpMyAdmin/ in the address bar of the browser, press Enter, you can enter the main interface of phpMyAdmin . Next, you can operate the MySQL database.

1. Create a database

In the main interface of phpMyAdmin, you can see the drop-down box of "Language-languange", we can Select the "Chinese - Chinese simplified" option in the drop-down box, and then there is a "Server connection proofreading". We usually choose the utf8_general_ci simplified Chinese encoding format to prevent garbled characters.

After the above settings are completed, I will start to create the database. Click on the database in the upper left corner and the following interface will appear:

Then enter your own database name in the text box, ours here is "php.cn", although we have set this encoding format at the beginning, but just in case, we can choose it again here "utf8_general_ci", then click the create button and then you can see the database you created in the left column, as shown below:

We can click on the database we created, and The database can be managed:

The above is the success of creating the database!

2. Modify the database

In the database management interface (picture above), there is an "Operation" button, click to enter the modification operation database page.

1. Enter the upper left corner of the modification page to create a data table for the current database. Enter the name of the data table to be created and the total number of fields in the two text boxes under the create data table prompt, and click Click the "Execute" button to enter the page for creating a data table structure, which we will introduce in detail in a later article.

2. You can rename the database in the upper right corner of the modification page. Enter the database name in the text box of "Rename the database to:" and click "Execute" to successfully modify the database name.

3. Delete the database

Also click the "Action" button to enter the modification page, and click on " Just below "New Data Table" is Delete Database. Click to delete the database.

Note:

The database is very important in our daily development. There is a lot of data in it. If you want to delete it, you must be careful. Once deleted, it cannot be restored. It is recommended to back up the database before deleting it!

Have you learned how to create and modify databases? In the next article, we introduce the data table. For details, please read " Detailed graphic explanation of data table addition, deletion and modification operations (phpMyAdmin usage tutorial 2)"!

【Related recommendations】

1. Relevant topic recommendations: "phpMyAdmin usage tutorial"

2. Related video courses Recommended: "MySQL Free Online Tutorial"

3. Online download of related tools: "phpMyAdmin Tool Download"

The above is the detailed content of Detailed graphic and text explanation of database addition, deletion and modification operations (phpMyAdmin usage tutorial 1). For more information, please follow other related articles on the PHP Chinese website!