How to insert data from 1 table to another table?

Question

1.00/5 (1 vote)

See more:

Hello, How can i insert the data from Table_A into Table_B?
i wanted to stored the ID(table_A) as StudentID(table_B)

What I have tried:

PROCEDURE table_A(
IN prm_ID
)
Begin
 INSERT INTO table_A
              (
              ID,
              name,
              course           
              )
  SELECT      StudentID,
              name,
              stu_course
  FROM        table_B
  WHERE       StudentID= prm_ID
  AND         NOT EXISTS (SELECT 1 FROM table_A WHERE ID= prm_ID);

Posted 16-Sep-20 21:19pm

BBO001

Updated 16-Sep-20 21:39pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-09-16T21:39:00

Solution 1

Your code does quite the opposite: it inserts data from Table_B into Table_A.

What you are looking for is SQL INSERT INTO SELECT Statement[^] which means the syntax is:

SQL

INSERT INTO DestinationTableName (<DestingationColumnList>)
SELECT <SourceColumnList> FROM SourceTableName
WHERE condition;

You have source and destination swapped.

Posted 16-Sep-20 21:39pm

OriginalGriff

Comments

BBO001 17-Sep-20 4:52am

i wanna insert my data from table A to Table B whenever i call the stored procedure

OriginalGriff 17-Sep-20 5:20am

And your code does it the other way...