How to delete all records in mysql except one?

W

Web Kyb2018-09-15 20:02:12

MySQL

Web Kyb, 2018-09-15 20:02:12

How to delete all records in mysql except for one, let's say we delete all records but leave only the record under 'id' = '2'
I found several sites on the Internet with a similar question, but the solutions that are described there do not work. Thanks in advance.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

Espleth, 2015-04-05
@Rabinzon

https://toster.ru/search?q=%D0%BA%D0%B0%D0%BA%D0%B...
there were so many questions...