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
468
January 20, 2021 07:29AM
187
January 20, 2021 12:35PM
232
January 21, 2021 01:59AM
172
January 21, 2021 11:09AM
206
January 21, 2021 12:13PM


Sorry, you can't reply to this topic. It has been closed.

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.