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


mySQL list modified procedures

Recently I had a requirement where I needed to update stored procedure on the server to reflect my local changes and we had a huge number of stored procedure, so I was trying to list stored procedures which have been modified after a specific date. In this tip I am going to share that SQL query … Continue reading mySQL list modified procedures