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=enserver=1db=chizzy_co_ukshow_query=ysql_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.
