Re: Consultar variables
Hola que tal Jose Manuel.
Lo que deberias usar son las sentencias preparadas.
http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html
Y te dejo un ejemplo:
set @columna = 'nombre';
set @strQuery=CONCAT('select ',@columna,' from clientes'); #asignas a una variable cadena la query preparada
prepare stnCuenta from @strQuery; #declaras la sentencia, y le asignas la query
execute stnCuenta; #ejecutas la sentencia
deallocate prepare stnCuenta; #borras la sentencia
Espero te haya servido
Subject
Views
Written By
Posted
2866
July 28, 2008 07:02AM
Re: Consultar variables
2141
July 28, 2008 10:31AM
2058
July 28, 2008 12:03PM
1894
July 28, 2008 12:32PM
1933
July 28, 2008 07:53PM
1901
July 29, 2008 04:32AM
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.