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 <my_table> and Index..." command.
Now, I am writing a Perl script which will connect and update this
Table. Mission accomplished regarding the connection. Here is my
question:
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".
Can someone also give me or point me to a code example of searching with
an index. I found th ecommand "$searchField{$key_field} = $val;" but
I'm stilllooking for documentation to see what this code does and if it
does what I want.
Thanks,
Don
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php