Topic: Setting shortcut for a particular query

[paragkalra]

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.

[corbin]

Errrr....  No I don't think there's any way to do that.

[fenway]

Stored procedures can do this... but why?