3 replies to this topic

[bigbob2]

The follwoing command in phpmyadmin deletes one entry (number 412254).

DELETE FROM `dbase_dbase`.`search_queries` WHERE `search_queries`.`search_id` = 412254;

I want to delete all entries in this table. Is there a command to delete all from this table or from a range (ie. from record 1 to record 100000).

Please help

Kev

[mattjt83]

DELETE FROM `dbase_dbase`.`search_queries` WHERE `search_queries`.`search_id` <= 100000;

So that *should* delete all records that are less than or equal to 100000

BACKUP before you start messing with your db!

[bigbob2]

mattjt83, on 12 January 2012, 23:22, said:

DELETE FROM `dbase_dbase`.`search_queries` WHERE `search_queries`.`search_id` <= 100000;

So that *should* delete all records that are less than or equal to 100000

BACKUP before you start messing with your db!

Awesome! Thanks, I will test it now.

Kev

[geoffreywalton]

If you look at the db in phpmyadmin you get a list of all tables.

You can choose the option to "Truncate" which empties the entire table.

HTH

G