Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Delete double entries from a table without primary key

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 14, rows affected: 13, absolute service time: 0,16 sec 
edit mode |  history  | discussion
   id lastprice updatetime updatems
1 211709 51370 09:30:00 0
2 211709 51370 09:30:01 0
3 211709 51370 09:30:01 500
4 211709 51370 09:30:02 0
5 211709 51370 09:30:02 0
6 211709 51370 09:30:03 0
7 211709 51370 09:30:04 0
8 211709 51370 09:30:04 300
9 211709 51370 09:30:04 300
   id lastprice updatetime updatems
1 211709 51370 09:30:00 0
2 211709 51370 09:30:01 0
3 211709 51370 09:30:02 0
4 211709 51370 09:30:03 0
5 211709 51370 09:30:04 0