How do I move certain columns from one table to another in SQL?

Question

So I have a table called QUEUE with the columns STUDENT_ID, S_NAME, PASSWORD I want to write an SQL statement to copy the values within only the first 2 columns (i.e. STUDENT_ID, S_NAME) to another table STUDENT with columns STUDENT_ID, S_NAME only.

I tried this

insert into student (student_id, s_name) as (student_id, s_name) from queue

I'm new to SQL so I'm pretty sure this is incorrect. Can someone please help me out with this? Thanks. :)

Why did you tag this with every database you can think of? Which one are you actually using? — John Conde
– John Conde, Commented Nov 1, 2016 at 19:02

Rahul · Accepted Answer · 2016-11-01 19:07:18Z

2

Use INSERT INTO .. SELECT FROM construct like

insert into student (student_id, s_name) 
select student_id, s_name from queue

answered Nov 1, 2016 at 19:07

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

1 Comment

eXPRESS Over a year ago

Just a note and I know but if anyone would have same problem but into db with already existing rows go here: stackoverflow.com/questions/2763817/… to Scott Bailey's answer. I myself got here first and this was not solution to my problem since it created new rows under existing ones.

Collectives™ on Stack Overflow

How do I move certain columns from one table to another in SQL?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related