Home >Database >Mysql Tutorial >How to create a table in phpmyadmin

How to create a table in phpmyadmin

angryTom
angryTomOriginal
2019-10-17 17:41:329703browse

How to create a table in phpmyadmin

phpMyAdmin creates a table. How does phpMyAdmin create a data table? phpMyAdmin is an excellent database management tool. Many friends use phpMyAdmin to manage databases when building websites. Now I will talk about how phpMyAdmin creates tables.

1. Open the phpmyadmin login page, enter the phpmyadmin login username and password, and then click Execute on the lower right to log in, as shown in the figure below.

How to create a table in phpmyadmin

2. After successfully logging in to phpmyadmin, you can create the table. If you do not have a database, click Database, enter the database name in the New Database input box under the Database tab, and then click Create to create a new database, as shown in the figure below.

How to create a table in phpmyadmin

#Note: You can skip this step if you have created a database.

3. Click the database list on the left side of phpmyadmin to select which database to create the table in, as shown in the figure below.

How to create a table in phpmyadmin

4. After selecting the database, click the "SQL" icon below the database, as shown in the figure below.

How to create a table in phpmyadmin

5. After opening the SQL input box, enter the statement for phpmyadmin to create the table here, and then click Execute on the lower right, as shown in the figure below.

How to create a table in phpmyadmin

6. After clicking, phpmyadmin prompts that the SQL statement has been successfully run, indicating that phpmyadmin has successfully created the table, as shown in the figure below

How to create a table in phpmyadmin

For more PHP related knowledge, please visit PHP Chinese website!

The above is the detailed content of How to create a table in phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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