Sutput the table definitions and cut and paste the new columns into a ALTER TABLE
table_name ADD column_name column-definition statement.
--- On Wed, 6/8/08, Jerry Schwartz <jschwartz@stripped> wrote:
> From: Jerry Schwartz <jschwartz@stripped>
> Subject: Transplanting table structure changes
> To: mysql@stripped
> Date: Wednesday, 6 August, 2008, 4:46 PM
> I've added about a dozen new columns to two tables in my
> development
> environment, and now I need to roll it out to our
> production environment.
> Can anyone suggest an easy way to do this? I want to avoid
> typos, as much as
> I can.
>
>
>
> I made the original changes with PHPMyAdmin, so I don't
> have any original
> script to re-use. The best idea I've come up with is to
> capture the output
> of SHOW CREATE TABLE and massage that, but I wonder if
> I'm missing
> something.
>
>
>
> The production environment has data in the "old"
> columns, and all of the new
> columns allow NULL, so all I really need to do is preserve
> the existing data
> and add the new columns.
>
>
>
> Although we've discussed this before, and I admit it
> makes no sense from the
> machine's point of view, I want to insert the new
> fields in a particular
> place for the benefit of the humans who will be using MS
> Access to view and
> filter these tables.
>
>
>
> Regards,
>
>
>
> Jerry Schwartz
>
> The Infoshop by Global Information Incorporated
>
> 195 Farmington Ave.
>
> Farmington, CT 06032
>
>
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
> <http://www.the-infoshop.com> www.the-infoshop.com
>
> <http://www.giiexpress.com> www.giiexpress.com
>
> www.etudes-marche.com
> __________________________________________________________
Not happy with your email
> address?.
Get the one you really want - millions of new email addresses available now at
> Yahoo! http://uk.docs.yahoo.com/ymail/new.html
