good morning
I am a novice programmer friends if I can be guided by fa
I need to update the rut of a supplier then I have this procedure almacendo
where more parameter to create a rut then updated
mysql stored procedure
the rut is unique for a vendor
1 the problem that I have is the rut rut that actuliza all suppliers
2 that I will be missing me
parameters added rut Rut_Change
REATE DEFINER=`root`@`localhost` PROCEDURE `SP_ACTULIZARPROVEEDOR`(IN Rut_Proveedor int,
IN Rut_Change int,
IN Proveedor VARCHAR(60),
IN Nombre VARCHAR(50),
IN Giro VARCHAR(50),
IN Direccion VARCHAR(60),
IN Ciudad VARCHAR(60),
IN Fono int,
IN Fax VARCHAR(45),
IN Correo VARCHAR(60),
IN web VARCHAR(100))
BEGIN
UPDATE proveedor SET
Rut_Proveedor = Rut_Change,Proveedor = Proveedor,Nombre = Nombre,Giro = Giro,Direccion = Direccion,Ciudad = Ciudad,Fono = Fono,Fax = Fax,Correo = Correo,Web = web
WHERE Rut_Prov ...
Go to the complete details ...