Asignar valor a variable en un SP

[gnzsoloyo]

Primero probemos esto:

Código MySQL:

DECLARE 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:

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

y luego

Código MySQL:

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