Gistrec

Удалить дубликаты из таблицы

Dec 5th, 2018
280
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.25 KB | None | 0 0
  1. # Удалить из таблицы `captcha`
  2. # все записи, где повторяется `result`
  3. # id - PK NN UQ AI
  4.  
  5. DELETE `a` FROM `captcha` AS `a`,
  6.     `captcha` AS `b`
  7. WHERE
  8.     `a`.`id` < `b`.`id`
  9.     AND `a`.`result` <=> `b`.`result`
Advertisement
Comments
  • User was banned
Add Comment
Please, Sign In to add comment