insert using where clause in SQL table dynamically

Question

I am having a table COMPONENTS of 3 columns (Sno,Component,Quantity) among which I am writing Sno and Component columns initially and I want to fill the column 'quantity' using some expression(ex: ((d1+d2)*d3) ) involving variables from another table SHEET(d1 int,d2 int ,d3 int,d4 int ,d5 int,d6 int).

Here I need to write values to quantity column based on value in Sno column from COMPONENTS table(components.sno).

I used to keep expression value in 'x' and trying to insert into COMPONENTS as shown below:

insert into components(Quantity) values(x) 
where components.sno='y'; [Y is inetger starting from 0 to 70]

But the above query showing error at where

Please suggest me best SQL query to achieve this! Thanks in Advance..!

mirkobrankovic · Accepted Answer · 2013-07-04 07:19:29Z

7

You can't do INSERT with WHERE clause unless it's WHERE NOT EXISTS, so just do:

INSERT INTO components(Quantity) VALUES(x)

Maybe you needed to do UPDATE

UPDATE components SET Quantity=x WHERE components.sno='y';

answered Jul 4, 2013 at 7:19

mirkobrankovic

2,3471 gold badge22 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mirkobrankovic Over a year ago

Did it help with your problem?

Sreedhar GS Over a year ago

@RavitejA, if an answer solve your problem, please upvote it.

Nemanja Trifunovic · Accepted Answer · 2016-08-08 17:17:22Z

-1

Use an IF statement before the insert and don't use the where clause:

If <your condition>
  Begin <your statement>
End

edited Aug 8, 2016 at 17:17

Nemanja Trifunovic

3,1351 gold badge20 silver badges20 bronze badges

answered Aug 8, 2016 at 16:06

user3408584

1

1 Comment

kenny_k Over a year ago

Hi, welcome to SO. To increase the chance of your response being accepted, and useful to future readers, I would suggest posting the entire text of the correct query, with code markdown (stackoverflow.com/editing-help#code).

Collectives™ on Stack Overflow

insert using where clause in SQL table dynamically

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related