Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Удалить из таблицы `captcha`
- # все записи, где повторяется `result`
- # id - PK NN UQ AI
- DELETE `a` FROM `captcha` AS `a`,
- `captcha` AS `b`
- WHERE
- `a`.`id` < `b`.`id`
- AND `a`.`result` <=> `b`.`result`
Advertisement