How to Develop Script to Move Data between Mysql Tables

Asked By Michael C Bates 10 points N/A Posted on - 11/17/2014

I have a large number of Mysql database tables. I need to move some records around from one table to the other but I do not know how to go about this. Please help me with you expertise to move data from one table to the next. What kind of script should I develop and what specific commands can accomplish this task?

• Status: Open
• Question Views: 644
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Batch scripting

Answered By Tanthle Yak 0 points N/A #190744

How to Develop Script to Move Data between Mysql Tables

To Transfer the data from one tale to another table by following methods:

** The INSERT INTO method

** The BCP/Bulk Insert method

** SELECT INTO method

The INSERT INTO method works with the following methodology

INSERT INTO Table2 ( <Columns>)

SELECT <Columns>

FROM Table1

WHERE < condition>

DELETE FROM Table1

WHERE<condition>

COMMIT;

The above is the simplest method

** The The BCP/Bulk Insert method copies data from one table to another in two steps.

1. Use BCP to extract the data and make it a text file.

2. Using BULK INSERT command transferring the records into the destination file.

** SELECT INTO method is used when previously created table is not there and wants the data to be transferred from one table to the newly created table.

SELECT <columns>

INTO tablename

About Tanthle Yak

Questions
0

Answers
100

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 12/29/2014
• Question Category: Batch scripting