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

what happen ? auto increment

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › what happen ? auto increment

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • June 12, 2003 at 7:14 pm #8031
      marques
      Member

      I'm tryng change alter a table structure (myISAM to inno db)

      The primary key have 3 columns and only one column is autoincrement.

      So, when a try make de change, SQLYog send me the message:

      Error No 1075

      Incorrect table definition

      There can only be one auto column and it must be defined as a key.

      what happens?

      Best regards,

      Marques, from Brasil

      [email protected]

    • June 12, 2003 at 7:22 pm #14497
      CalEvans
      Member

      go to the history tab, cut and paste into a message the exact create table that SQLyog is trying to execute.

      =C=

    • June 12, 2003 at 7:53 pm #14498
      Ritesh
      Member
      Quote:
      when a try make de change

      What type of change do you mean?

    • June 12, 2003 at 7:53 pm #14499
      marques
      Member

      [16:51:50][ 3 ms] show fields from `ppp`.`funcoes_exercidas`

      [16:51:50][ 3 ms] show keys from `ppp`.`funcoes_exercidas`

      [16:51:50][ 45 ms] show table status from `ppp`

      [16:52:06][ 3 ms] alter table `ppp`.`funcoes_exercidas` ,drop primary key, add primary key (`Codigo_Empresa`, `Codigo_Func`, `Sequencia` ) ,type=InnoDB comment='InnoDB free: 10240 kB' row_format=dynamic

    • June 12, 2003 at 7:55 pm #14500
      marques
      Member

      What type of change do you mean?

      MyIsam to inno db

    • June 13, 2003 at 8:07 am #14501
      Ritesh
      Member

      If you want to just change the Table Handler, select the Table in the Object Browser and select Change Table Type To -> InnoDB from the popup menu.

      HTH

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