How to Select First Last or Range of Records in MySQL Table
When using MySQL, and wanting to retrieve the first n records from a table, one can use the LIMIT function. It can also be used to grab a range of records, not just a series starting with the first record. Use as follows:
SELECT * FROM yourtable LIMIT yourlowlimit,yourhighlimit;
This will return all rows between the number yourlowlimit and yourhighlimit inclusive.
e.g. SELECT FROM users LIMIT 20,50
will return the rows 20, 21, 22,…, 49, 50
This post was written by Content Curator on November 16, 2009
Outlook XP / 2002 limit of 2 gigabytes on .PST and .OST files
Using Office XP, also called Office 2002, could limit you to a 2 gigabyte file size for postoffice .PST and offline storage .OST files.
Microsoft has posted an article addressing this problem, and it recommends updating to the latest Office XP Service Pack. This was performed on a system today, and the successful SP3 update did not remove the 2 gig limitation.
Posted under Microsoft, Office
This post was written by Content Curator on October 10, 2006
