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 0 reply threads
  • Author
    Posts
    • March 15, 2006 at 2:55 pm #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

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