sql insert row based on other table value

Question

I have 2 tables called table1 and table2. table1 has key, condition, level and conditionvalue columns and table2 has key and value columns.

table1 rows

key         condition  level     conditionVal
 1              >        error       10
 1              =        info         5    
 2              <        warning      5
 2              >        info         20

I will get inputs(key and value) from user or other source and that values I need to insert into table2 based on the following condition.

if key is 1 and value is > 10 or value is equal to 5 then i need to insert. if key is 2 and value is > 20 or value is less than 5 then i need to insert.

How to acheive this using sql insert statement.

which DBMS? SQL Server, Oracle, MySQL,...?

user4622594
– user4622594

2016-12-15 13:04:57 +00:00
Commented Dec 15, 2016 at 13:04 — user4622594
– user4622594, Commented Dec 15, 2016 at 13:04
Have a search for Dynamic SQL for your prefered DBMS

JohnHC
– JohnHC

2016-12-15 13:05:24 +00:00
Commented Dec 15, 2016 at 13:05 — JohnHC
– JohnHC, Commented Dec 15, 2016 at 13:05
CASE in sql can help you?

Milaci
– Milaci

2016-12-15 13:06:47 +00:00
Commented Dec 15, 2016 at 13:06 — Milaci
– Milaci, Commented Dec 15, 2016 at 13:06
I am sqlite3 for my C application

Arun
– Arun

2016-12-15 15:56:53 +00:00
Commented Dec 15, 2016 at 15:56 — Arun
– Arun, Commented Dec 15, 2016 at 15:56

Jibin Balachandran · Accepted Answer · 2016-12-15 13:09:14Z

0

Try this:

IF EXISTS(
           SELECT 1
           WHERE (@Key=1 AND (@value>10 @value=5) ) OR (@Key=2 AND (@value>20 OR @value<5))
                                                                                            )

INSERT INTO Table2 (column1) VALUES (@values)

answered Dec 15, 2016 at 13:09

Jibin Balachandran

3,4491 gold badge27 silver badges39 bronze badges

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

Comments

nimour pristou · Accepted Answer · 2016-12-15 13:36:23Z

0

try this :

INSERT INTO table2 (KEY, value)
  SELECT KEY , conditionVal 
    FROM table1 
    WHERE KEY IN
      (SELECT KEY
      FROM table1
      WHERE (KEY        =1
      AND (value        >10
      OR value          =5) )
      OR (KEY           =2
      AND (value        >20
      OR value          <5))
      AND 
    conditionVal IN
      (SELECT conditionVal
      FROM table1
      WHERE (KEY        =1
      AND (value        >10
      OR value          =5) )
      OR (KEY           =2
      AND (value        >20
      OR value          <5))

answered Dec 15, 2016 at 13:36

nimour pristou

1531 silver badge8 bronze badges

1 Comment

Arun Over a year ago

Table1 rows are dynamically added. So I need a dynamic solution

Collectives™ on Stack Overflow

sql insert row based on other table value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related