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

This article is about how mysql creates a table. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

1. After logging in successfully, first go to a database (not the database server)

Use T1; / / T1 is the database name

two。 Create database tables in this database

2.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:

1 CREATE TABLE table_name (column_name column_type)

Examples are as follows:

1 create table tb3 (2 id smallint unsigned auto_increment primary key,3 username varchar (20) not null4)

2.2 View the established table structure

The syntax format is:

1 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 records

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

3.1 insertion of records

The syntax format for the insertion of records:

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

Examples are as follows:

1 insert tb3 (id,username) values (4djona')

3.2 query records

Syntax format:

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

Examples are as follows:

Select id,username from tb3

Thank you for reading! About how mysql creates a table to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.