Shulou(Shulou.com)06/01 Report--

This article mainly introduces the use of phpmyadmin examples, introduced in the article is very detailed, has a certain reference value, interested friends must read!

First, 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 check". We generally choose utf8_general_ci simplified Chinese coding format to prevent garbled.

When the above settings are set up, I will start to create the database. Click on the database at the top left and the following interface will appear.

Then enter your database name in the text box. Here is "php.cn". Although we have set this encoding format at the beginning, we can select "utf8_general_ci" again here, and then click the create button in the left column to see the database you created, as shown below:

We can manage the database by clicking on the database we created.

Second, modify the database

In the database management interface (above), there is an "Action" button, click to go to the page to modify the operation of the database.

1. Go to the top left of the modification page and perform the operation of creating a data table on the current database. Enter the name of the data table and the total number of fields to be created in the two text boxes under the prompt information of the data table, respectively, and click the "execute" button. We will go to the create data table structure page, which will be described in detail in the following article.

two。 At the top right of the modification page, you can rename the database, enter the database name in the text box of "rename the database to:", and click "execute" to change the database name successfully.

Delete the database

Also click the "Action" button to enter the modification page, directly below the "New data Table" is to delete the database, click to delete the database

Note:

Database in our daily development is very heavy, there is a lot of data, if you want to delete must be careful, once deleted can not be restored, it is recommended to back up the database before deletion!

The above is all the contents of this article "examples of the use of phpmyadmin". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.