insert value and select from column from and to the same table

Question

My_Table (Contains Columns A & B). I need to Check Column A and if it does not equal a designated fixed value Add a new record using the designated fixed Value for Column A and existing Column B Value for Column B.

Is there way to combine VALUES & SELECT into a INSERT Statement? Temp Table? How do I do this?

Thanks

What language is this for? SQL?

neontapir
– neontapir

2011-10-12 03:19:09 +00:00
Commented Oct 12, 2011 at 3:19 — neontapir
– neontapir, Commented Oct 12, 2011 at 3:19

Brian · Accepted Answer · 2011-10-12 03:29:10Z

Your question's a bit unclear, but I think this should do it

INSERT INTO My_Table (A, B) (SELECT "DESIGNATED_VALUE", B FROM My_Table WHERE A <> "DESIGNATED_VALUE")

Collectives™ on Stack Overflow

insert value and select from column from and to the same table

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related