如何在mysql中创建同义词 [英] How to create a synonym in mysql

问题描述

我在数据库B中有一个视图，该视图在数据库A中使用.

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

我只是想写点东西

SELECT * FROM MYSYNONYMNAME

在mysql中可以做到吗?我在手册中没有看到太多内容.

Is that possible to do in mysql? I didn't see much in the manual..

推荐答案

无法在mysql中创建

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

这篇关于如何在mysql中创建同义词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！