param_record_id int OUTPUT

[Jassim Rahma]

In SQL Server, I was doing this in the stored procedure: param_record_id int OUTPUT then I : set param_record_id = scope_identity() how can id o the same in mySQL stored procedure?

[Lost User]

jrahma wrote:

how can id o the same in mySQL stored procedure?

select sequence_name_goes_here.currval
from dual;

There's an example both on using sequences and returning values in the manual over here[^] :)

I are Troll :suss: