MemSQL OutPut Parameter?

Dears is there is an alternative to out parameter in stored procedure ,
as we need to return Id ( last_insert_id())
return will not suite our scenario

Hi Adel,

We currently don’t have support for IN/OUT/INOUT prefixes to function parameters so function parameters are always pass-by-value in Stored Procedure/User-Defined Functions.

I would like to understand why you can’t use return clause to return the value? Please note, you can use Record datatype (https://docs.memsql.com/v7.1/reference/sql-reference/procedural-sql-reference/record/), which is equivalent to C/C++'s struct, to return multiple scalar values from the Stored Procedure. If this still doesn’t work for you, I would like to know why you can’t use Return clause to return the value of last_insert_id().