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

Structure Sync Error

forums forums SQLyog SQLyog BETA Discussions Structure Sync Error

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #9535
      Gianni_T
      Member

      When I try to sync 2 database with different table type and FK I got an useless sync file:

      Code:
      /* Alter table in Second database */
      alter table `giva_online`.`a_enti_contattati`, Engine=InnoDB

      /* Alter table in Second database */
      alter table `giva_online`.`a_entrate`,
      add KEY `FK_a_entrate` (`convivente_id`), Engine=InnoDB,

      Notice the absence of semicolon at the end of each statement.

    • #20868
      peterlaursen
      Participant

      Also the comma before Engine is not in accordance with http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

      The comma should be inserted BEFORE #2, #3 etc alter_specification not AFTER #1. And it does not work with MySQL 5.1 this way! I think we did fix a similar comma-issue before?

      With MySQL 5.1:

      alter table t1 Engine=InnoDB;

      >> works

      alter table t1, Engine=InnoDB;

      >> Error Code : 1064

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Engine=InnoDB' at line 1

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