How mysql creates a table
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.
