MySQL table creation statement

MySQL table creation statement

1. Create a user table

User_id	Name	Age	Sex	Phone

 

Create table user (user_id int (4) primary key auto_increment,

Name varchar (20 ),

Age int (4 ),

Sex varchar (4 ),

Phone varchar (10 ));

 

After the creation is complete, as follows:

 

 

PS: I used varchar2 to create the table at the beginning, but it failed because mysql does not support varchar2. Here, we can only use varchar.