Search
Search

SQL insert data into a table from another table

debugcn Published at Dev
19
user3419519

I'm having a problem trying to insert some values into a table. I made an empty table with the fields

id(primary key) 
association_id 
resource_id

I have another table with

resource_id
association_id

and another one with

id(coresponding to the association_id in the former one)
image

I want to insert the resource_id and association_id from the first populated table, where the image field of the coresponding id from the last table is not empty.

I tried this:

INSERT IGNORE INTO `logo_associations` (``,`association_id`,`resource_id`)
SELECT 
        ``,
        `a`.`association_id`,
        `a`.`resource_id`
FROM doc24_associations_have_resources a
Join doc24_associations    An on a.association_id = An.id 
WHERE An.image<>''

but it does not work

Kevin Hogg

My experience is based on SQL Server but the SQL may be very similar

 INSERT INTO DestinationTable
        (association_id, resource_id)
 SELECT LNK.assocication_id,
        LNK.resource_id
   FROM LinkTable AS LNK
        INNER JOIN ImageTable AS IMG ON IMG.id = LNK.association_id
                   AND IMG.image IS NOT NULL

Above I assume the following:

  1. Tables are named DestinationTable, LinkTable, and ImageTable respectively
  2. In DestinationTable the primary key (id) is auto generated

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

select from one table, insert into another table oracle sql query

From Dev

How to select data from a table and insert into another table?

From Dev

SQL insert data into a table from another table

From Dev

Trigger to insert data from source table and another table

From Dev

insert data in sql server from other table

From Dev

Insert data from column of a table and store to column another table

From Dev

MySQL - Insert table data from another table

From Dev

Insert data into table in SQL Server from XML

From Dev

Transfer data from one table to another on insert

From Dev

How to select data from a table and insert into another table?

From Dev

Insert data from table to another table using PL/SQL

From Dev

Sql copying a data from table to another table

From Dev

Procedure to insert a data from one table to another table after calculations

From Dev

SQL Server : query to insert data into table from another table with different struct

From Dev

How to pull data from sql, add columns to a row and insert it into another sql table?

From Dev

Insert Data From One Table to Another Table with default values

From Dev

PHP/SQL Insert data from form and insert data from another table using prepared statement

From Dev

SQL insert data dynamic column name from another table

From Dev

MySQL - Insert table data from another table

From Dev

MySQL insert into column data from another table

From Dev

how to insert data from another table with id from my table

From Dev

Insert new rows into table but copy data from another row in the table

From Dev

Trigger update the same table with data from another table after insert

From Dev

Cron php update/insert one sql table from another and delete data from old table

From Dev

How to insert data from another table into an existing table, with an autoincrementing id?

From Dev

SQL Server: Insert into table selecting from another table

From Dev

Insert Data From One Table to Another Table and Add New Values

From Dev

insert data from one table to a single column another table with no relation

From Dev

Insert Data From One Table To Another - MySQL

Related Related

  1. 1

    select from one table, insert into another table oracle sql query

  2. 2

    How to select data from a table and insert into another table?

  3. 3

    SQL insert data into a table from another table

  4. 4

    Trigger to insert data from source table and another table

  5. 5

    insert data in sql server from other table

  6. 6

    Insert data from column of a table and store to column another table

  7. 7

    MySQL - Insert table data from another table

  8. 8

    Insert data into table in SQL Server from XML

  9. 9

    Transfer data from one table to another on insert

  10. 10

    How to select data from a table and insert into another table?

  11. 11

    Insert data from table to another table using PL/SQL

  12. 12

    Sql copying a data from table to another table

  13. 13

    Procedure to insert a data from one table to another table after calculations

  14. 14

    SQL Server : query to insert data into table from another table with different struct

  15. 15

    How to pull data from sql, add columns to a row and insert it into another sql table?

  16. 16

    Insert Data From One Table to Another Table with default values

  17. 17

    PHP/SQL Insert data from form and insert data from another table using prepared statement

  18. 18

    SQL insert data dynamic column name from another table

  19. 19

    MySQL - Insert table data from another table

  20. 20

    MySQL insert into column data from another table

  21. 21

    how to insert data from another table with id from my table

  22. 22

    Insert new rows into table but copy data from another row in the table

  23. 23

    Trigger update the same table with data from another table after insert

  24. 24

    Cron php update/insert one sql table from another and delete data from old table

  25. 25

    How to insert data from another table into an existing table, with an autoincrementing id?

  26. 26

    SQL Server: Insert into table selecting from another table

  27. 27

    Insert Data From One Table to Another Table and Add New Values

  28. 28

    insert data from one table to a single column another table with no relation

  29. 29

    Insert Data From One Table To Another - MySQL

HotTag

Archive