How to create a synonym in mysql

mysql, synonym

Solution

It's not possible to create synonyms in mysql like it's possible in Oracle

Problem

I have a view in database `B` which I use in database `A`. I would like to create a synonym to this view. Because right now each time I have to write the query like this ``` Select * from DBNAME.VIEWNAME ``` rather I just want to be able to write ``` SELECT * FROM MYSYNONYMNAME ``` Is that possible to do in mysql? I didn't see much in the manual..

Original source