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 ?