paragkalra Posted September 12, 2009 Share Posted September 12, 2009 Hello Folks, Is there a way we can set shortcuts in mysql. Take for instance I use "select * from <mytable>" after every 5 minutes to check the values of various rows. So I was think if I can get a way to set a shorcut to above query something like 'set myquery = "select * from <mytable>" This is should fetch me all the rows from <mytable> after executing "myquery" on "mysql" prompt as shown below: mysql>myquery For people knowing Linux - I want something like "alias" command. Link to comment https://forums.phpfreaks.com/topic/173976-setting-shortcut-for-a-particular-query/ Share on other sites More sharing options...
corbin Posted September 12, 2009 Share Posted September 12, 2009 Errrr.... No I don't think there's any way to do that. Link to comment https://forums.phpfreaks.com/topic/173976-setting-shortcut-for-a-particular-query/#findComment-917087 Share on other sites More sharing options...
fenway Posted September 12, 2009 Share Posted September 12, 2009 Stored procedures can do this... but why? Link to comment https://forums.phpfreaks.com/topic/173976-setting-shortcut-for-a-particular-query/#findComment-917358 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.