>Hi
>I have a detail.dbf with 2 indexes
>ref_no char(10), type char(10), date date(8), account char(10), itemcode char(10)
>index on type+ref_no tag ref_no && type is bill type like INVOICE,CASHBILL,PURCHASE,CN,DN.....
>index on itemcode+account+dtos(date) tag itemcode descend
>
>use detail
>set order to ref_no
>seek m.type+m.ref_no
>do something..........
>
>set order to itemcode
>seek m.itemcode+m.account
>scatter all previous data and gather into temp cursor........
>
>how to create this table and indexes with mysql syntax ?
>how to play around with these index just like vpf table and index seek with mysql coding ?

Quick google search suggests that MySQL does have covering indexes http://www.mysqlperformanceblog.com/2006/11/23/covering-index-and-prefix-indexes/