Re: How do I use index files?

2001-01-19 Thread Don
> Don wrote: > > > > > > Prior to updating, I want to search the table to see if my Key exists. > > > > That way, I can add it or just update the associated fields. How do I > > > > tell my script which Index file to use? I can't seem to find the > > > > equivalent of the dBase style "Set Order

Re: How do I use index files?

2001-01-19 Thread Gerald L. Clark
Don wrote: > > > > Prior to updating, I want to search the table to see if my Key exists. > > > That way, I can add it or just update the associated fields. How do I > > > tell my script which Index file to use? I can't seem to find the > > > equivalent of the dBase style "Set Order to". > > >

Re: How do I use index files?

2001-01-19 Thread Don
> > Prior to updating, I want to search the table to see if my Key exists. > > That way, I can add it or just update the associated fields. How do I > > tell my script which Index file to use? I can't seem to find the > > equivalent of the dBase style "Set Order to". > > Errr... If I understand

RE: How do I use index files?

2001-01-19 Thread Carsten H. Pedersen
> Hi, > > I have installedMySQL 3.23.31 Good. > I have read many docs. Even better! > ... [cut] > Prior to updating, I want to search the table to see if my Key exists. > That way, I can add it or just update the associated fields. How do I > tell my script which Index file to use? I can't

How do I use index files?

2001-01-19 Thread Don
Hi, I have installedMySQL 3.23.31 I have read many docs. I have successfully crated a database with tables and index files. Several of my tables have two index files. One is the PRIMARY field that I specified. The other is a seperate index I created on other fields, using the "alter table and