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

This article will explain in detail how to build tables in MySQL database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1. After logging in successfully, first enter a certain database (not the database server)

Use T1; / / T1 is the database name

2. Create a database table in this database

1) first establish the table structure (which can be understood as the column name of the table, that is, the field name) in the actual production process, the table structure needs to be carefully designed.

The common syntax format is:

CREATE TABLE table_name (column_name column_type)

Examples are as follows:

Create table tb3 (id smallint unsigned auto_increment primary key, username varchar (20) not null4)

2) View the established table structure

The syntax format is:

Show columns from [table name]

For example:

Show colums from tb3

You can see that the table structure in table T3 contains two fields: id,username

The values of both fields are not allowed to be empty, and the id field is the primary key.

3. Insertion and search of

Table records in the database correspond to rows in the table.

1), record insertion

The syntax format for the insertion of records:

Inset {Table name} (filed1,field2,....) Values (value1,value2,....)

Examples are as follows:

Insert tb3 (id,username) values (4)

2), query records

Syntax format:

Select {filed1,filed2,...} from {Table name}

Examples are as follows:

Select id,username from tb3

On how to build tables on the MySQL database to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.