How to store MySQL query results in another Table?

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
W开发者_Python百科HERE
  labels.Resource=images.Resource
  AND labels.Resource=shortabstracts.Resource
  AND labels.Resource=types.Resource;

---

If the table doesn't exist (and you e.g. don't want to create it because it may have lots of column names) you can create it on the fly...

Query:

CREATE TABLE another_table SELECT /* your query goes here */

---

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;

---

if your table dosen't exist then

CREATE TABLE new_table SELECT //write your query here

if your table exist then you can just insert query

INSERT INTO new_table SELECT //write your query here

For more check here and here

---

INSERT INTO another_table SELECT /*your query goes here*/

---

In SQLite Studio, I noticed that "AS" keyword is needed:

Query:

CREATE TABLE another_table AS SELECT /* your query goes here */