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

Meticul · August 3, 2017 2:31PM

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 4, 2017 11:28AM

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.

David Atkinson · August 4, 2017 11:33AM

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 4, 2017 11:36AM

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

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

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk