retrive rows affected number

[dannG]

Hello!
I'm new in MYSQL.
I'm trying to migrate some MS Sql Stored Procedures in MySql. Here is the MSSQL stored procedure.

CREATE PROCEDURE CB_UserLogin
(
    @User      nvarchar(50),
    @Pass   nvarchar(50),
    @ID_Util int OUTPUT
)
AS

SELECT 
    @ID_Util = fID_Util
    
FROM 
    tblUtiliz
    
WHERE 
    fUtilizator = @User
  AND 
    fParola = @Pass

IF @@Rowcount < 1 
SELECT 
    @ID_Util = 0

My problem is the in translating the last part of this SP. I need the number of affectes rows by the first part of SP.

The following code is not accepted as a correct one.
Any help will be appreciated! Thx

CREATE PROCEDURE CB_UserLogin
(
    VUser      varchar(50),
    VPass   varchar(50),
    OUT VID_Util int 
)
begin

SELECT 
    @ID_Util = fID_Util
    
FROM 
    tblUtiliz
    
WHERE 
    fUtilizator = @User
  AND 
    fParola = @Pass;

IF Row_count() < 1 then @ID_Util = 0
end if;
end;

 

[dannG]

Hi
I think I solved the problem. Maybe someone need it...

CREATE PROCEDURE CB_UserLogin
(
    VUser      varchar(50),
    VPass   varchar(50),
    OUT VID_Util int 
)
begin

SELECT 
    fID_Util
    
FROM 
    tblUtiliz
    
WHERE 
    fUtilizator = @User
  AND 
    fParola = @Pass;

IF Row_count() < 1 then 
 SET VID_Util = 0;
Else
 Set VID_Util=fID_Util;
end if;
end;

cheers!