Introduction to MySQL database environment (6) [figure] _ MySQL

Introduction to MySQL database environment (6) [figure] of course, we can directly use SQL statements to create the table, you only need to enter the following SQL statement in the "SQL editor" tab on the right of-13 and click "execute.

Create table if not exists user (
ID int (10) unsigned not null auto_increment,
Username varchar (50 ),
Password varchar (50 ),
Email varchar (50 ),
Primary key (ID ),
Unique key id (ID ),
KEY ID_2 (ID)
);

2.5.5 add a user data entry

To allow logon in later system development, we first add a user record to the user table. Select the "demo"> "user" option on the left of-13, and the data list of the table is displayed on the "Data Browser" tab on the right, as shown in 2-17.

-17 add a user data entry

Add a User admin in the-17 table, set the password to admin, and the e-mail address to abc@163.com. Click the "√" button in the toolbar to submit and save.

Of course, you can also add the data by executing the following SQL statement in the "SQL editor:

Insert into user VALUES ("1", "admin", "admin", "abc@163.com ");

It should be noted that the SQL execution function of the "SQL editor" can be easily developed.