sql - How to create an MySQL query alias? -


for example use this

select * tab1; 

every 5 minutes.

is there way set alias p can do

p 

instead , query executed?

this calls view, in case isn't shorter: create view p select * tab1;
you'd use as: select * p

it more interesting more complex queries though.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -