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 2 reply threads
  • Author
    Posts
    • June 5, 2007 at 12:48 pm #10360
      webtask
      Member

      I have SQLYog 6 RC2

      DDL for my table includes key definition with data size like that:

      Code:
      …
      KEY `IDX_NAME` (`NAME`(32))
      …

      But, when SQLYog runs duplicate table data/structure command it uses DDL without width in key definition for those field and MySQL return an error No. 1170

    • 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 2 reply threads
  • You must be logged in to reply to this topic.