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

quick qn

forums › forums › SQLyog › Using SQLyog › quick qn

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 16, 2003 at 12:41 am #8243
      Vee
      Member

      What does MUL refer to?

      I had to re-index stuff to get my innodb r/ships to work and many of the intended foreign keys (I think)

      read as KEY (key name) but in the table descriptions instead of saying PRI like they do for Primary key its says MUL

      what's it stand for and what's the deal with it?

    • November 17, 2003 at 8:24 am #15235
      Shadow
      Member

      MUL stands for MULTIPLE_KEY_FLAG which indicates a non-unique index field. The abbreviation is used by MySql and not by SQLyog.

    • November 17, 2003 at 8:30 am #15236
      Shadow
      Member

      Foreign keys are excellent examples of such keys as multiple records may refer to the same field in the referenced table.

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