I Need To Update My Sql Database.

[peterlaursen]

Maybe you can use an INSERT .. SELECT construction. If your table has the columns (id, col1, col2, col3)

Code:

INSERT INTO table1 (col1, col2, col3) SELECT col1, col2, col3 FROM table2;

.. note that primary/unique key is not specified in (col1, col2, col3) list. Import the two dumps to two different tables first.

However if you have Foreign Keys or other types of references between tables I do not believe it is possible in simple SQL. It will require some programming logic to ensure that references between rows of different tables are kept intact. You may use your favorite scripting/programming language or a Stored Procedure.

[Author]

Posts