Delete Command

Anon

How can I delete at once... 300 entries in a database...

I need to delete from entry 300 to entry 600...

DELETE from Guest WHERE ID= ????

How can I tell hime from x to y?

Anon

Got the command...

simply where ID>NUMBER

Anon

Remember to also put in an upper limit:

where ID>300 and ID<600

Anon

delete
from Guest
where id >= 300 and id <=600

Anon

What if you want to delete 300 records between 500 and 1000 in no particular order
for eg:
delete the records 500 , 502, 505, 506, 507, 520, 521..... 900, 950, 959, 999.

Anon

use the IN statement:

delete from table where id in(500,502,505,506,507,520,521);

Anon

Its ok if you have to delete only 6 such records ....but if U need to delete over 300 such records from 500 - 1000 ..... then what ??

Anon

Then you add 500 or 1000 numbers to the IN statement, php is great at creating strings :-)
(sql accepts very long queries)

But ofcourse there are more intelligent ways of doing it, because there has to be a reason why those particular records must be deleted.
If that reason is stored in the same table you can just say things like:

delete from table where datefield<date_sub(now(),interval 3 day);

to delete all records that have a date of more than 3 days ago.

Anon

Does MySQL support if conditions in the where clause.... I have heard that it does

Vincent can you answer this
http://www.phpbuilder.com/forum/read.php3?num=2&id=117519&thread=117381

Anon

IF in a WHERE clause? how would you write a query with IF in a where clause?
WHERE is one big IF.
MySQL does support IF in the SELECT:

SELECT IF(field_1=1,field_2,field_3) FROM table;

this returns field_2 if field_1 contains 1, or field_3 in all other cases.