Construct Dynamic Query Inside MySQL Stored Procedure

Sometimes we need to construct a query inside a stored procedure. Lets say we have fields like day1, day2, day3..., and we need to fetch day1, for some other case we need to fetch for day2 and so on. Why write different procedures just write a single SP construct the query by passing the day number and … Continue reading Construct Dynamic Query Inside MySQL Stored Procedure

Advertisements