Inserting data into table using Select

Question

I have a table employee1 and employee2 where I would like to insert data from one table to another using select based on a condition such as

INSERT INTO EMPNO, EMPNAME, EMPAGE, EMPSALARY, EMPDESIGNATION SELECT EMPNO, EMPNAME, 0, '', EMPDESIGNATION WHERE EMPID=25

This is what I want to achieve as there are some values which i don't want to supply because they are default or for some other reason but this is not allowed.

Can you tell me how can I achieve this

RichardTheKiwi · Accepted Answer · 2012-10-26 10:38:39Z

2

INSERT INTO employee2
           (EMPNO, EMPNAME, EMPAGE, EMPSALARY, EMPDESIGNATION)
     SELECT EMPNO, EMPNAME, 0, '', EMPDESIGNATION
       FROM employee1
      WHERE EMPID=25;

You can specify the columns you want to provide values for, and then provide values for only those columns.

answered Oct 26, 2012 at 10:38

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

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

Comments

Diego · Accepted Answer · 2012-10-26 10:39:20Z

0

insert INTO employee2 (EMPNO)
SELECT EMPNO from employee1

answered Oct 26, 2012 at 10:39

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Collectives™ on Stack Overflow

Inserting data into table using Select

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related