MySQL stored procedure return null -


i have stored procedure out parameter (code):

select code = right(concat(repeat(0, 6), (select max(convert(code, int)) + 1 enterprises)), 6) 

if exec it, return null value, if execute single query, works right. why?

rename parameter, try write (parameter name code_param) -

select   right(concat(repeat(0, 6), (select max(convert(code, int)) + 1 enterprises)), 6) code_param; 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -