Select and insert on the same table

Question

Can you tell me what is wrong with this query:

INSERT INTO properties  ( f_gen_id(NULL) , 'ASHAgroup18E' , entity , effective_dt , property_key , property_value , created_by , create_ts , updated_by , update_ts )  SELECT f_gen_id(NULL) , 'ASHAgroup18E' , entity , effective_dt , property_key , property_value , description , created_by , create_ts , updated_by , update_ts -- 'UIL-Migration', CURRENT_TIMESTAMP, 'UIL-Migration', CURRENT_TIMESTAMP  FROM properties WHERE group_key = 'ASHAgroup18B';

What makes you think there's something wrong with the query? — HoneyBadger
– HoneyBadger, Commented Nov 13, 2018 at 7:44
INSERT INTO tablename (column1, column2, ...) SELECT ..., i.e. spccify insert columns. — jarlh
– jarlh, Commented Nov 13, 2018 at 7:46

Joakim Danielson · Accepted Answer · 2018-11-13 08:55:50Z

In the INSERT part you should have column names, not a function

INSERT INTO properties (f_gen_id(NULL),...

replace this with the name of the primary key/id column

INSERT INTO properties (id,...

Update I guess also the second column in the INSERT is incorrect since it contains a string. Again, replace it with a column name

Collectives™ on Stack Overflow

Select and insert on the same table

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related