是否将结果联接到新表中？

Question

我可以成功地连接两个表，但我正在尝试将连接的结果输出到一个新表中。

下面的代码抛出了一个语法错误，但如果省略了"into“行，则可以正常工作。需要说明的是，连接语句没有问题，而是"into“语句有问题。

 SELECT evictions.uniqueid_neighborhoods.id, evictions.uniqueid_neighborhoods.neighbor_1, 
evictions.sanfrancisco_evictions_backup2.Breach,
evictions.sanfrancisco_evictions_backup2.NonPayment,
evictions.sanfrancisco_evictions_backup2.Nuisance,
evictions.sanfrancisco_evictions_backup2.IllegalUse
** This causes code to fail 
into evictions_by_commArea 
from evictions.uniqueid_neighborhoods
inner join evictions.sanfrancisco_evictions_backup2 on evictions.uniqueid_neighborhoods.id = evictions.sanfrancisco_evictions_backup2.id

Answer 1

MySQL使用CREATE TABLE AS

CREATE TABLE evictions_by_commArea as
    SELECT un.id, un.neighbor_1, 
           sfe.Breach,
           sfe.NonPayment,
           sfe.Nuisance,
           sfe.IllegalUse
    from evictions.uniqueid_neighborhoods un join
         evictions.sanfrancisco_evictions_backup2 sfe
         on un.id = sfe.id;

我还引入了可用别名，因此查询更容易编写和读取。