How to store MySQL query results in another Table?

MysqlSqlDatabase

Mysql Problem Overview

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;

Mysql Solutions

Solution 1 - Mysql

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 */

Solution 2 - Mysql

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;

Solution 3 - Mysql

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

Solution 4 - Mysql

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

Solution 5 - Mysql

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

Query:

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

Categories
Recommended Mysql Solutions
Recommended Sql Solutions
Recommended Database Solutions

Previous Solution:

Can I use reflection to inspect the code in a method?

C#Reflection

Next Solution:

jquery - check length of input field?

Jquery

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionTasawer KhanView Question on Stackoverflow
Solution 1 - MysqlphatrickView Answer on Stackoverflow
Solution 2 - MysqlcodaddictView Answer on Stackoverflow
Solution 3 - Mysqltarikul05View Answer on Stackoverflow
Solution 4 - MysqlYour Common SenseView Answer on Stackoverflow
Solution 5 - MysqlAjit KumarView Answer on Stackoverflow