Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Handler MYSQL Statement

Example of Handler MYSQL Statement

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

Example of Mysql Handler


HANDLER table1 READ index2