Re: Really dumb question... deleting everything but newest 100 rows?

I was thinking something along those lines, but phpmyadmin gives an error. The table currently has way too many rows (32362), could this have to do with it? Warning: Unable to jump to row 0 on MySQL result index 4 in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php on line 223 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/libraries/ob.lib.php on line 53 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 23 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 24 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 25 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 26 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 27 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 29 Database mydb running on localhost Error SQL-query : delete from mytable order by col desc limit 100, -1 MySQL said: You have an error in your SQL syntax near 'order by col desc limit 100, -1' at line 1 Back <http://www.ecritters.biz/PhpMyAdmin/db_details.php?lang=en&server=1&db=chizzy_co_uk&show_query=y&sql_query=delete+from+%60topics%60+order+by+id+desc+limit+100%2C+-1> Marco Tabini wrote:

If you have a column that gives you the "newness" of each row--I'm assuming a date here: delete from my_table order by date_inserted desc limit 100, -1 This should work... I recommend a db backup first :-) Marco ------------ php|architect - The magazine for PHP Professionals The monthly worldwide magazine dedicated to PHP programmers Check us out on the web at http://www.phparch.com On Sat, 2002-11-23 at 17:38, Leif K-Brooks wrote:

I know this is a dumb question, but how would I delete everything but the first 100 results returned from a query? I know I'd use limit, but my mind's going blank as to the exact syntax. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.