Hello, I am trying to write better SQL. I am

Question

Hello, I am trying to write better SQL. I am

currently inserting data with a loop in perl into psql database and i would like to do it in one transaction...

I select one row of ids and i need to put it into other table like VALUES (12345, ?) where ? is the id i get from the SELECT. Thanks

0

04.02.2021

2 ответов

8 просмотров

klimi Автор вопроса

Thomas
INSERT INTO table SELECT ... FROM otherTable

ah thanks, i found out i can use constant tables for this

0

04.02.2021

Thomas · Accepted Answer

Thomas

INSERT INTO table SELECT ... FROM otherTable

0

04.02.2021

Похожие чаты

Hello, I am trying to write better SQL. I am

2 ответов

Похожие вопросы