mindapolis Posted April 8, 2012 Share Posted April 8, 2012 In mysql is there a way to save a query? Link to comment https://forums.phpfreaks.com/topic/260536-save-a-query/ Share on other sites More sharing options...
trq Posted April 8, 2012 Share Posted April 8, 2012 Your going to need to be more specific. Save a query to where and for what? You can create a stored procedure. Link to comment https://forums.phpfreaks.com/topic/260536-save-a-query/#findComment-1335315 Share on other sites More sharing options...
cpd Posted April 8, 2012 Share Posted April 8, 2012 Or a view. Queries can automatically be cached if repeatedly called as well... I believe caching is on by default. Link to comment https://forums.phpfreaks.com/topic/260536-save-a-query/#findComment-1335435 Share on other sites More sharing options...
mindapolis Posted April 9, 2012 Author Share Posted April 9, 2012 I mean save it in the database so it could be run daily if need be. Link to comment https://forums.phpfreaks.com/topic/260536-save-a-query/#findComment-1335508 Share on other sites More sharing options...
fenway Posted April 9, 2012 Share Posted April 9, 2012 5.1 has a event scheduler... but cron really is the way to go. Link to comment https://forums.phpfreaks.com/topic/260536-save-a-query/#findComment-1335516 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.