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

Double Key

forums › forums › SQLyog › Using SQLyog › Double Key

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 14, 2007 at 12:08 pm #10183
      Carlo
      Member

      Hi, I'm a new user 😆

      I'm creating a database with SQLyog, but I have a problem: I have to create a table with a double key,

      for example:

      product (name, code, price, release_date)

      How can I create a double key? 😕

      thanks a lot

    • February 14, 2007 at 3:53 pm #23414
      peterlaursen
      Participant

      I am not sure I understand you notation and the term 'double key'.

      An index that uses more columns?

      You want to use the 'name' and 'code' columns for that 'key' ??

      If you want it to be a PRIMARY key you do from 'ALTER TABLE' – just check both columns

      If it is not a PRIMARY key but just a plain index you to from 'manage indexes'.

      Both are available from the table context menu.

    • February 15, 2007 at 6:41 pm #23415
      Carlo
      Member
      peterlaursen wrote on Feb 14 2007, 04:53 PM:
      An index that uses more columns?

      yes 😉

      thank you very much

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