T
T
tupoi_nub2016-05-09 16:50:23
SQL
tupoi_nub, 2016-05-09 16:50:23

It is necessary to delete lines (a lot) on request, why doesn't it work, why?

DELETE FROM users WHERE username IN (Artem2t76531,Artem2457,tester346,Artem245746,Artem2t56453)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Denis Knyazev, 2016-05-09
@axaxa_man

DELETE FROM users WHERE username IN ( 'Artem2t76531', 'Artem2457', 'tester346' , 'Artem245746' , 'Artem2t56453' )

T
timusKul, 2016-05-10
@timusKul

doesn't even write any errors? sampling under such condition works?
Well, what DBMS do you use?
you can use Truncate, but there are some troubles

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question