Structure Sync Error

[Gianni_T]

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.

[peterlaursen]

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

[Author]

Posts