I've got a simple database to keep some emails, Can there be any method of getting your email in the database in categories of one hundred emails ???
This is actually the database structure
Table structure for table `emails` -- CREATE TABLE IF NOT EXISTS `emails` ( `email` varchar(100) NOT NULL, `ip` varchar(15) NOT NULL, `timestamp` datetime NOT NULL, PRIMARY KEY (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
The perfect outcome is always to obtain the first 100 emails, make a move and then obtain the next 100 and make a move else.
Thanks and sorry for my british
Then for the following one,
LIMIT 100, 100, after which
LIMIT 200, 100, and so forth.
The very first number (when you will find two) may be the offset.
Make use of the SQL [cde] syntax to paginate via SQL.
One factor to notice, for performance reasons, you need to make sure that you are utilizing
LIMIT <offset>, <row_count> inside your paginated query which you're utilizing an index. The MySQL Performance blog includes a good explanation.