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.
