MySQL Forums
Forum List  »  Spanish

Ocultar campo en el select "Atencion Expertos"
Posted by: Luis Di Nisio
Date: October 30, 2015 06:37AM

Buenos dias Expertos,

En esta ocasión me dirijo a ustedes para consultar la formula para ocultar un campo (Operación matemática) cuando se realiza el select, por ejemplo:


Tengo la siguiente consulta:

select ID,Fecha, Hora, IF(@INDEZ=0, 0 , ( INDE1 - @INDEZ ) )Salida , (@INDEZ:=INDE1) from cgnatcol01_variables_new join (select @INDEZ:=0)T1 where Fecha='2015-10-24';

La salida es la siguiente:

+------+------------+----------+--------+-----------------+
| ID | Fecha | Hora | Salida | (@INDEZ:=INDE1) |
+------+------------+----------+--------+-----------------+
| 943 | 2015-10-24 | 00:00:00 | 0 | 1888229 |
| 944 | 2015-10-24 | 00:05:00 | 2793 | 1891022 |
| 945 | 2015-10-24 | 00:10:00 | 732 | 1891754 |
| 946 | 2015-10-24 | 00:15:00 | 1059 | 1892813 |
| 947 | 2015-10-24 | 00:20:00 | 2266 | 1895079 |
| 948 | 2015-10-24 | 00:25:00 | 3863 | 1898942 |


Quisiera que la operación matemática "(@INDEZ:=INDE1)" no se imprima.

Espero sus comentarios

Saludos,

Luis Di Nisio

Options: ReplyQuote


Subject
Views
Written By
Posted
Ocultar campo en el select "Atencion Expertos"
2897
October 30, 2015 06:37AM


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.