Home > Database > phpMyAdmin > body text

phpmyadmin preliminary usage tutorial

王林
Release: 2019-12-13 11:10:58
Original
16413 people have browsed it

phpmyadmin preliminary usage tutorial

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.

phpmyadmin preliminary usage tutorial

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

phpmyadmin preliminary usage tutorial

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, just in case, we can select 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:

phpmyadmin preliminary usage tutorial

We can click on the database we created, and Manage the database

phpmyadmin preliminary usage tutorial

2. Modify the database

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

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 information, 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.

phpmyadmin preliminary usage tutorial

3. Delete database

Similarly click the "Operation" button to enter the modification page, and click on " Just below "New Data Table" is to delete the database. Click to delete the database

phpmyadmin preliminary usage tutorial

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!

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of phpmyadmin preliminary usage tutorial. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!