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. Quote 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. Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.