MENU
HANDLER
| HANDLER tbl_name OPEN [ [AS] alias]
HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST } [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name READ { FIRST | NEXT } [ WHERE where_condition ] [LIMIT ... ] HANDLER tbl_name CLOSE |
| HANDLER is faster than SELECT, and is sometimes a more natural way to treat data. |
| HANDLER…OPEN makes a table accessible with subsequent HANDLER…READ, until HANDLER…CLOSE is called or the session terminates. |
| HANDLER...READ fetches a row where the index specified satisfies the given values and the WHERE condition is met. If an index spans multiples columns, you can specify values for only the leftmost columns. For example: HANDLER tb READ idx = (1,2,3) HANDLER tb READ idx = (1,2) HANDLER tb READ idx = (1) |
| Use the quoted ‘PRIMARY’ to use a table’s PRIMARY KEY: HANDLER tb READ ‘PRIMARY’ pk… |
| LIMIT fetches specific number of (instead of one) rows. The syntax is specified in 5.4.1. |