Foros del Web - Ver Mensaje Individual

gnzsoloyo · #2 (**permalink**) 13/12/2012, 11:13

Primero probemos esto:

Código MySQL:

Ver originalDECLARE customer_id INT;
SET customer_id = 0;
SELECT id_customer
FROM `ps_customer` 
WHERE firstname = 'Juan' AND lastname= 'Perez'
INTO customer_id; 
SELECT customer_id;

Luego probemos esto:

Código MySQL:

Ver originalSET @var = 0;
SELECT @var := id_customer 
FROM `ps_customer` 
WHERE firstname = 'Juan' AND lastname= 'Perez';
SELECT @var;

y luego

Código MySQL:

Ver originalSET @var = 0;
SELECT @var := id_customer 
FROM `ps_customer` 
WHERE firstname = 'Juan' AND lastname= 'Perez';
SELECT CAST(@var AS UNSIGNED) idcustomer;