This article mainly introduces how to keep only the latest 1000 records in mysql in php and related examples and database structures. It is very comprehensive and can be referenced by other interested parties.
This article mainly introduces how to keep only the latest 1000 records in mysql in php and related examples and database structures. It is very comprehensive and can be referenced by other interested parties.
<? Php mysql_connect ("localhost", "root", "root"); mysql_select_db ("test"); // keep the latest 1000 records $ limit = 1000; $ query = "select 'id' from 'News'"; $ result = mysql_query ($ query); $ num = mysql_num_rows ($ result); if ($ num> $ limit) {$ query = "select 'id' from 'News' order by 'id' desc limit ". $ limit; $ result = mysql_query ($ query); mysql_data_seek ($ result, $ limit-1); $ data = mysql_fetch_array ($ result ); $ query = "delete from 'News' where 'id' <' $ Data [id] '"; if (mysql_query ($ query) {echo" database has been ". $ num. "record, redundant ". ($ num-$ limit ). "The record has been deleted successfully and is still available ". $ limit. "record! ";}} Else {echo" insufficient data records ". $ limit! No need to delete! ";}?>
Test. SQL
-- PhpMyAdmin SQL Dump
-- Version 3.1.5-rc1
--
--
-- Host: localhost
-- Generation Date: August 19, 2010
-- Server version: 5.0.18
-- PHP version: 5.2.8
SET SQL _MODE = "NO_AUTO_VALUE_ON_ZERO ";
/*! 40101 SET @ OLD_CHARACTER_SET_CLIENT = @ CHARACTER_SET_CLIENT */;
/*! 40101 SET @ OLD_CHARACTER_SET_RESULTS = @ CHARACTER_SET_RESULTS */;
/*! 40101 SET @ OLD_COLLATION_CONNECTION = @ COLLATION_CONNECTION */;
/*! 40101 set names utf8 */;
--
-- Database: 'test'
--
----------------------------------------------------------
--
-- Table structure 'News'
--
Create table if not exists 'new' ('id' int (11) unsigned not null auto_increment, 'title' varchar (256) not null, primary key ('id ')) ENGINE = InnoDB default charset = gb2312;
The above is all the content of this article. I hope you will like it.