Insert into with select [closed]

Question

Insert into with select [closed]

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I need to do an insert of type

INSERT INTO your_table SELECT * FROM temp_table;

But, I need the id, and the second column that is an id_fk I can set.

I need to do a transfer of the tuple to another user, copying all information but passing new id, f_id and name

Anything wrong?

sql

asked by anonymous 01.11.2017 / 19:31

2 answers

I wonder if I'm doing this ajax in the right way? Force open .EML file in email client

score 1 · Answer 1

Try to do this as follows:

INSERT INTO tabela (nome_campo1,nome_campo2) VALUES (select nome_campo1,nome_campo2 from tabela)

Note: Just replace 'field_name' with the fields in question, remembering that both the 'INSERT INTO' and 'SELECT' fields should be the same. Note 2: Since you did not specify in which database you are doing this SQL (Mysql, Postgree, SQlServer), I used the PostgreSQL syntax, maybe you need to adapt the code to the database you are using

score 0 · Answer 2

you just change the select, and do not use *

INSERT INTO your_table 
              SELECT 
                 '1' as novo_id, 
                 '2' as nova_fk, 
                 t.outros_campos 
              FROM temp_table t;