Start MySQL (create table) 2

Drop   Table   If   Exists T_user;
Create   Table T_user (
ID Int   Primary   Key Auto_increment,
U_uid Varchar ( 50 ),
U_pwd Varchar ( 20 ),
U_name Varchar ( 20 )
);
/* Insert into t_user values ('admin', '123456', 'administrator 1 '); */
Insert   Into T_user (u_uid, u_pwd, u_name) Values ( ' Admin ' , ' 123 ' , ' Administrator 1 ' );
Insert   Into T_user (u_uid, u_pwd, u_name) Values ( ' Bb ' , ' 123 ' , ' Administrator 2 ' );
Insert   Into T_user (u_uid, u_pwd, u_name) Values ( ' Bb ' , ' 123 ' , ' Administrator 2 ' );
Update T_user Set U_name = ' Administrator bbb ' Where ID = 1 ;
Delete   From T_user Where ID = 3 ;
Select   *   From T_user;

Note: To enable auto-increment columns, you must specify other column names.

 Insert into t_user values ('admin', '123456', 'administrator 1 ')

In this case, the addition fails.

Comments --CodeHowever, a space must be added to the backend. Otherwise, an error may be returned /**/