设置列以自动从引用的表中提取数据

I have one column called 'speeding' in a table containing many other columns. This column contains an integer that is foreign key to an entry on a table named Speeding. This table has columns 1-25 and an id that is referenced by the 'speeding' column from the first table.

我在一个包含许多其他列的表中有一个名为“speeding”的列。此列包含一个整数,该整数是名为Speeding的表上的条目的外键。此表包含第1-25列以及第一个表中“超速”列引用的ID。

Besides using join, is there any setting I can set on 'speeding' to make it automatically pull the associated data from the table Speeding?

除了使用join之外,是否有任何设置我可以设置'speeding'以使其自动从表Speeding中提取相关数据?

1 个解决方案

#1

You could create a view, a view is basically a SQL statement that is stored on the MySQL server and acts like a table

您可以创建一个视图,一个视图基本上是一个存储在MySQL服务器上的SQL语句,就像一个表

CREATE VIEW ViewName AS
SELECT tbl1.data, tbl2.speeding
FROM tbl1
INNER JOIN tbl2 ON tbl2.key = tbl1.key;

http://dev.mysql.com/doc/refman/5.0/en/create-view.html

You then use the view as you would use any table

然后,您可以像使用任何表一样使用视图

SELECT data, speeding
FROM ViewName

1 个解决方案

#1

更多相关文章

随机推荐