mySQL subquery limit

by

Try this:

DELETE 
FROM posts 
WHERE id not in (
      SELECT * FROM (
            SELECT id 
            FROM posts 
            ORDER BY timestamp desc limit 0, 15
      ) 
      as t);

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. mysql error cant fix the error [duplicate]
  3. MySQL pivot row into dynamic number of columns
  4. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  5. How do you set a default value for a MySQL Datetime column?
  6. How should I resolve –secure-file-priv in MySQL?
  7. node-mysql multiple statements in one query
  8. MySQL server startup error ‘The server quit without updating PID file’
  9. Select last row in MySQL
  10. Best type of indexing when there is LIKE clause [duplicate]
  11. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  12. Can a number be used to name a MySQL table column?
  13. Difference between Key, Primary Key, Unique Key and Index in MySQL
  14. What’s the difference between MyISAM and InnoDB? [duplicate]
  15. MySQL: Split comma separated list into multiple rows
  16. How to start MySQL with –skip-grant-tables?
  17. How can I access the MySQL command line with XAMPP for Windows?
  18. When to use STRAIGHT_JOIN with MySQL
  19. Remove Primary Key in MySQL
  20. Difference in MySQL JOIN vs LEFT JOIN
  21. Get most recent row for given ID
  22. Is there a simple way to convert MySQL data into Title Case?
  23. What’s the best database structure to keep multilingual data? [duplicate]
  24. Using an IF Statement in a MySQL SELECT query
  25. How do you stop MySQL on a Mac OS install?
  26. Insert/ Update random date in MySQL
  27. How to determine which database is selected
  28. Replace null with 0 in MySQL
  29. Array data type, split string,
  30. How can I make a table in MySQL called “order”?

Leave a Comment