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) _______________________________________________ http://mm.ilug-bom.org.in/mailman/listinfo/linuxers
