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

Duplicate Table Data/structure

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Duplicate Table Data/structure

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 5, 2007 at 12:55 pm #24090
      peterlaursen
      Participant

      Confirmed that there is one or more issue with length of indexes specified on string type columns.

      I created an Index of length = 3 on a table and dublicated that table.

      In the dublicated table it became length = 767.

      SQLyog version 6.0 final.

    • June 5, 2007 at 1:04 pm #24091
      peterlaursen
      Participant

      addition:

      the SQL generated is like:

      “create table `peter`.`child_copy` ( KEY `child`( `child`))type=InnoDB”

      .. no lenght specification in the create statement!  the values '767' is probably the default for my server version!

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