mysql - 如何在 mysql 中索引(或查看)两个表？

Question

aid  |  name                   udi | aid | name | description
------------------------      -------------------------
1       text                   1     1      text     text

我想将这些表合并到一个表中(实时更新)

我怎样才能使用这样的索引:

aid | aname |  uid | uname | udescription

Answer 1

Create view YOURviewName as   

select
a.aid,
a.name as aname,
u.aid as uid,
u.name as uname,
u.description as udescription
from
a inner join u on a.aid = u.aid