MySQL Forums
Forum List  »  Spanish

Uso de HANDLER
Posted by: francisco aragon
Date: January 20, 2021 07:29AM

Muy buenas ando estudiando mysql y veo que en la documentacion no hay aportes para este tema.

//Esto funciona
HANDLER tbl_name OPEN [ [AS] alias]

//Esto no funciona
HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...)
[ WHERE where_condition ] [LIMIT ... ]

//Esto funciona
HANDLER tbl_name READ index_name { FIRST | NEXT | PREV | LAST }
[ WHERE where_condition ] [LIMIT ... ]

//Esto funciona
HANDLER tbl_name READ { FIRST | NEXT }
[ WHERE where_condition ] [LIMIT ... ]

//Esto funciona
HANDLER tbl_name CLOSE


┬┐La pregunta es porque esta expresion no funciona?
HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...)
[ WHERE where_condition ] [LIMIT ... ]

La verdad que la velocidad se nota
0.00027 HANDLER declaracion
0.00061 select declaracion


La lista de declaraciones provadas son

$select[] = "HANDLER memoria OPEN";
$select[] = "HANDLER memoria READ FIRST";
$select[] = "HANDLER memoria READ NEXT";

$select[] = "HANDLER memoria READ `PRIMARY` FIRST";
$select[] = "HANDLER memoria READ `PRIMARY` NEXT";
$select[] = "HANDLER memoria READ `PRIMARY` NEXT";
$select[] = "HANDLER memoria READ `PRIMARY` PREV";
$select[] = "HANDLER memoria READ `PRIMARY` LAST";
$select[] = "SELECT * FROM `memoria` WHERE `id_medicion` = 308";

//esta es la que no funciona
$select[] = "HANDLER memoria READ `PRIMARY` = (id_medicion)";

$select[] = "HANDLER memoria CLOSE";

Options: ReplyQuote


Subject
Views
Written By
Posted
Uso de HANDLER
112
January 20, 2021 07:29AM
29
January 20, 2021 12:35PM
26
January 21, 2021 01:59AM
29
January 21, 2021 11:09AM
28
January 21, 2021 12:13PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.