Webyog Forums > Structure Sync Error

Webyog Forums > SQLyog > SQLyog BETA Discussions

Gianni_T

Mar 15 2006, 02:31 PM

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

Mar 15 2006, 02:55 PM

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

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.