How to move only fields from One Table to another table in Mysql

I have purchased Mysql Data Compare, now my query is, I want just to move one field from table of first database to table of another database, please show me the way, how to implement it. current software shows create table script, I want Alter table script.

Meticul August 03, 2017 14:31

Comments

3 comments

Please reply fast, I am stuck in the middle of code, as I have two different server with same kind of database and move Table fields from beta server to live server.

Meticul August 04, 2017 11:28

0
Are you talking about MySQL Compare or MySQL Data Compare?

Have you looked at the deployment script (towards the end of the deployment wizard) for the ALTER script?

David Atkinson August 04, 2017 11:33

0
See https://www.red-gate.com/simple-talk/sql/sql-tools/mysql-compare-the-manual-that-time-forgot-part-1/#deploying

David Atkinson August 04, 2017 11:36

0

Add comment

Please sign in to leave a comment.

How can we help you today?

How to move only fields from One Table to another table in Mysql

Comments

Add comment