Poonam P spewed into the ether:
Hi, I am trying to write a small script to fetch a certain record (say record no. 25) from a mysql db.
You will need to use a WHERE clause in your select query.
SELECT item1 from list1 WHERE itemnum = 25
(Assuming you have a column itemnum containing the record number).
I have written the following script after reading a Mysql book, but I am not able to understand as to how to fetch a given record no., or get records between a given range... like all records between 24th - 29th ..
There is a pocket reference for SQL, which has a lot of information of SQL, and various statement details. It is published by ORA, and should be available from CB, or any other place.
<snip>
Devdas Bhagat
------------------------------------------------------------ Nettaxi.com has merged with RAE Systems, Inc. NTXY.OB the stock ticker symbol has changed to RAEE.OB (NASDAQ)