Starting with the development of new operational data store, with integration of the portal.
The most handy feature is MySql procedure alongwith out parameters to pass the values on to a function or the front-end.
Example:
drop procedure rec_cnt;
delimiter //
create procedure rec_cnt(out param1 int)
begin
select count(*) into param1 from employee;
end//
delimiter ;
call rec_cnt(@param1);
select @param1;
Results:
20097 rows returned
Please like us on Google if you like our posts!! And feel free to leave your comments/suggestion.
No comments:
Post a Comment
Please share your thoughts and let us know the topics you want covered