Inserting data from one table to another table values based on column condition

Question

I want to know if there is a way to achieve this. I have two table, I want to move data from one table to another table.

TableA:
ID  Name  Option
----------------------
1  First   Add into box
2  Second  Don't Add
3  Third   Add into box

TableB
ID Name    Option          Status
--------------------------------
1  First   Add into box    Approved 
2  Second  Don't Add       Reject
3  Third   Add into box    Approved

I want to insert data from TableA to tableB but tableB have one more column, where the value of it depends on option column data. If column value is Add into box then it should be inserted as approved into TableB else Reject has to be inserted.

MySQL and SSMS (SQL Server Management Studio) have no relationship. As it's name suggests, SSMS is for SQL Server, which is a completely different product to MySQL. What RDBMS are you really using? — Thom A
– Thom A ♦, Commented Jun 20, 2022 at 10:25
There is definitely a way to achieve this it's quite trivial but please first tag the correct database — Nick.Mc
– Nick.Mc, Commented Jun 20, 2022 at 10:32

Ankitha Gowda · Accepted Answer · 2022-06-20 11:25:22Z

2

If you are using MSSQL, the below query would work.

Insert into TableB (Id,Name, Option, Status) 
select Id,Name, Option, CASE when Option = 'Add into box'  then 'Approved' ELSE 'Rejected' END
From TableA

answered Jun 20, 2022 at 11:25

Ankitha Gowda

1571 gold badge2 silver badges7 bronze badges

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

3 Comments

Mike Over a year ago

Hello @Ankitha, Thank you! it worked, didn't know this was that simple.

Nick.Mc Over a year ago

@Mike since this appears to be SQL Server, I will tag the correct database. Please make sure you do thisin future.

Mike Over a year ago

@Nick.McDermaid, Thank you! I was actually confused with these terms: sql-server and MySql and sql.

Collectives™ on Stack Overflow

Inserting data from one table to another table values based on column condition

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related