mysql查询结果存储_如何将MySQL查询结果存储在另一个表中？

How to store results from following query into another table. Considering there is an appropriate table already created.

SELECT labels.label,shortabstracts.ShortAbstract,images.LinkToImage,types.Type

FROM ner.images,ner.labels,ner.shortabstracts,ner.types

WHERE

labels.Resource=images.Resource

AND labels.Resource=shortabstracts.Resource

AND labels.Resource=types.Resource;

解决方案

You can use the INSERT INTO TABLE SELECT....syntax:

INSERT INTO new_table_name

SELECT labels.label,shortabstracts.ShortAbstract,images.LinkToImage,types.Type

FROM ner.images,ner.labels,ner.shortabstracts,ner.types

WHERE labels.Resource=images.Resource AND labels.Resource=shortabstracts.Resource

AND labels.Resource=types.Resource;