如何在MySQL中创建表别名 [英] How do I create a table alias in MySQL

问题描述

我正在将MS Access应用程序(已将表链接到MSSQL Server)迁移到MySQL.

I am migrating an MS Access application (which has linked tables to a MSSQL Server) to MySQL.

作为克服某些MSAccess表命名问题的一种方法，我正在寻找一种解决方案以添加一个MySQL表别名，该别名将指向MySQL数据库中的现有表.理想情况下，我想在mysql中创建别名"dbo_customers"，该别名也指向mysql中的customers表.

As a means to overcome some MSAccess table naming problems, I am seeking a solution to add a MySQL table alias that will point to an existing table in the MySQL database. Ideally I would like to create the alias 'dbo_customers' in mysql that would point to the customers table also in mysql.

要清楚，我不是 ，不想在这样的查询中为表名加上别名:

To be clear I am not wanting to alias a table name inside a query like this:

SELECT * FROM customers AS dbo_customers

但是我希望能够发出以下查询:

But rather I would like to be able issue the following query:

SELECT * FROM dbo_customers

并使其从客户表返回数据.

and have it return data from the customers table.

推荐答案

离我远去

CREATE VIEW dbo_customers AS
SELECT * FROM customers

也许不是最好的解决方案，但是应该可以使用，因为视图是可更新的.绝对适用于只读

Maybe not the best solution but should work as the view is updatable. Will definitely work for Read Only

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