MYSQL query question - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » MYSQL query question

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

28th Aug 07 at 18:32

Is it possible to select from say 1000 records, but in two parts.

ie Get the first 500 records, do something with them, then get the next 500 records and process them?

I know how to limit one request but not to carry on where it left off

Dan Lewis

Member

Registered: 31st Jan 05
Location: Leicestershire
User status: Offline

28th Aug 07 at 18:35

im sure there is a way but what you could do is create a new col with and increasing number for each new record then select the data from set points

Nismo

Member

Registered: 12th Sep 02
User status: Offline

28th Aug 07 at 18:45

yeah if its an exect amount and each record has an ID number of somesort then do X with results ID1-500 then do XY with records ID501-1000 etc...

Steve

Premium Member

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline

28th Aug 07 at 18:48

the problem is, i need to generate a mass email which is easy enough, but my smtp server allows only 452 email requests at once, maybe if i split the emailing task up it will work?

Ian

Site Administrator