Home >Database >Mysql Tutorial >How to get table entry fields in mysql

How to get table entry fields in mysql

coldplay.xixi
coldplay.xixiOriginal
2020-10-28 15:42:104046browse

Mysql method of obtaining table item fields: first call a database in the MySQL database; then create a data table containing certain fields in the database; then enter the data value of the field; finally query a certain field in the data table All values ​​in a field.

How to get table entry fields in mysql

Mysql method of obtaining table entry fields:

1. First, call a database in the MySQL database

How to get table entry fields in mysql

2. Then, create a data table containing certain fields in the database

How to get table entry fields in mysql

3. Next, view Check whether the data table is created successfully. Check the structure and use the DESC statement

How to get table entry fields in mysql

4. The current data table is empty and has no data. Therefore the data needs to be inserted into the data table. INSERT INTO

How to get table entry fields in mysql

5, then enter the data value of the field, VALUES

How to get table entry fields in mysql

6, the data input is completed, and the final query All values ​​in a field in the data table. If you need to query the value of the name field. Enter the query statement as shown in the picture and press Enter

How to get table entry fields in mysql

More related free learning recommendations: mysql tutorial (video)

The above is the detailed content of How to get table entry fields in mysql. 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