Unsupported Screen Size: The viewport size is too small for the theme to render properly.

I Need To Update My Sql Database.

forums forums SQLyog Using SQLyog I Need To Update My Sql Database.

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #30102
      peterlaursen
      Participant

      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.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.