Remove two of the same data from MySQL

As the following table structure:

CREATE TABLE' T_user ' (' ID ')int( One) not NULL,  `user_name`varchar( -)DEFAULT NULL, ' phone 'varchar( One)DEFAULT NULL, ' status 'int( One)DEFAULT NULL, ' Create_time 'timestamp NULL DEFAULT NULL, ' Update_time 'timestamp NULL DEFAULT NULL,  PRIMARY KEY(' id ')) ENGINE=InnoDBDEFAULTCHARSET=Latin1;

First, query SQL as follows:

Select User_name,phone,status,create_time,update_time
From T_user,

Select User_name,phone,status,create_time,update_time
From T_user
Union
Select User_name,phone,status,create_time,update_time
From T_user;

Go to the heavy SQL as follows

Select User_name,phone,status,create_time,update_time
From T_user
Union
Select User_name,phone,status,create_time,update_time
From T_user;

Results

Remove two of the same data from MySQL