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

Column Order Ignored

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Column Order Ignored

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 2, 2005 at 11:39 pm #9335
      led_belly
      Member

      Hi,

      I've noticed that the SQLyog Structure Synchronization Tool does not highlight differences in column order. Suppose I have two different tables in two different databases that look like the following:

      DB1->Table1

      id

      title

      desc

      DB2->Table2

      id

      desc

      title

      Now suppose I ran INSERT INTO db2.table2 SELECT * FROM db1.table1…

      I'm using the utility to track these kinds of subtle differences so that I can catch the kinds of problems a query such as this would cause. Any suggestions? Am I missing something?

    • November 3, 2005 at 4:19 am #19669
      Ritesh
      Member

      This is a known issue.

      We plan to fix this in one of the future versions of SQLyog.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.