Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Unanswered: update a MySQL database with new structure

    I have a Mysql database that has production data. We have developed a new updates to this application, therefore the new database has some additional fields Columns to be added / updated in the tables.

    What is the easy and automated way to update the old db with the new structure, but keeping the data intact.

  2. #2
    Join Date
    Feb 2012
    Posts
    44
    there is no other way than this:

    Code:
    ALTER TABLE name ADD name VARCHAR(60) AFTER name;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •