Difference between keys and indexes

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Randell D.
    #1

    Difference between keys and indexes


    Can anyone tell me what the difference is between keys and indexes?

    Much appreciated,
    randelld


    Tags: None
    • @(none).adelphia.net
      #2
      Re: Difference between keys and indexes

      Randell D. wrote:[color=blue]
      > Can anyone tell me what the difference is between keys and indexes?
      >
      > Much appreciated,
      > randelld
      >
      >[/color]
      http://www.mysql.com/doc/en/CREATE_TABLE.html explains:
      # KEY is a synonym for INDEX....etc... .

      fw_error_www
      http://www.mysql.com/doc/en/Indexes.html


        Comment

        • Randell D.
          #3
          Re: Difference between keys and indexes

          "@(none).adelph ia.net" <""jgreenaw\"@( none).adelphia. net"> wrote in message
          news:3f42f079$0 $270$45beb828@n ewscene.com...[color=blue]
          > Randell D. wrote:[color=green]
          > > Can anyone tell me what the difference is between keys and indexes?
          > >
          > > Much appreciated,
          > > randelld
          > >
          > >[/color]
          > http://www.mysql.com/doc/en/CREATE_TABLE.html explains:
          > # KEY is a synonym for INDEX....etc... .
          >
          > http://www.mysql.com/doc/en/Indexes.html
          >[/color]

          Luvely Juvely...

          Thanx


            Comment

            • swdev1
              #4
              Re: Difference between keys and indexes

              RandellD -
              this is covered in its entirety in CJ Date's Book - An Intro to SQL -
              considered the do all textbook written by the god.
              There are several different things going on here .
              but in essence - you can index on any column you want.
              Keys, on the other hand - typically set up either a uniqueness or a foreign
              table reference .
              There are primary keys, foreign keys, candidate keys, alternate keys ..
              but typically primary keys are set up in mysql as part of the 'identity'
              column, and is set up
              as auto-incrementing .

              your mileage may vary, of course .
              mondo regards [Bill]


              --
              William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
              email.
              FREE LONG DISTANCE -> mailto:excel-info@efgroup.ne t
              mySql / VFP / MS-SQL
              "Randell D." <you.can.email. me.at.randelld@ yahoo.com> wrote in message
              news:THB0b.7854 42$ro6.15729491 @news2.calgary. shaw.ca...[color=blue]
              >
              > Can anyone tell me what the difference is between keys and indexes?
              >
              > Much appreciated,
              > randelld
              >
              >[/color]


                Comment

                • swdev1
                  #5
                  Re: Difference between keys and indexes

                  RandellD -
                  this is covered in its entirety in CJ Date's Book - An Intro to SQL -
                  considered the do all textbook written by the god.
                  There are several different things going on here .
                  but in essence - you can index on any column you want.
                  Keys, on the other hand - typically set up either a uniqueness or a foreign
                  table reference .
                  There are primary keys, foreign keys, candidate keys, alternate keys ..
                  but typically primary keys are set up in mysql as part of the 'identity'
                  column, and is set up
                  as auto-incrementing .

                  your mileage may vary, of course .
                  mondo regards [Bill]


                  --
                  William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
                  email.
                  FREE LONG DISTANCE -> mailto:excel-info@efgroup.ne t
                  mySql / VFP / MS-SQL
                  "Randell D." <you.can.email. me.at.randelld@ yahoo.com> wrote in message
                  news:THB0b.7854 42$ro6.15729491 @news2.calgary. shaw.ca...[color=blue]
                  >
                  > Can anyone tell me what the difference is between keys and indexes?
                  >
                  > Much appreciated,
                  > randelld
                  >
                  >[/color]


                    Comment

                    • swdev1
                      #6
                      Re: Difference between keys and indexes

                      RandellD -
                      this is covered in its entirety in CJ Date's Book - An Intro to SQL -
                      considered the do all textbook written by the god.
                      There are several different things going on here .
                      but in essence - you can index on any column you want.
                      Keys, on the other hand - typically set up either a uniqueness or a foreign
                      table reference .
                      There are primary keys, foreign keys, candidate keys, alternate keys ..
                      but typically primary keys are set up in mysql as part of the 'identity'
                      column, and is set up
                      as auto-incrementing .

                      your mileage may vary, of course .
                      mondo regards [Bill]


                      --
                      William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
                      email.
                      FREE LONG DISTANCE -> mailto:excel-info@efgroup.ne t
                      mySql / VFP / MS-SQL
                      "Randell D." <you.can.email. me.at.randelld@ yahoo.com> wrote in message
                      news:THB0b.7854 42$ro6.15729491 @news2.calgary. shaw.ca...[color=blue]
                      >
                      > Can anyone tell me what the difference is between keys and indexes?
                      >
                      > Much appreciated,
                      > randelld
                      >
                      >[/color]


                        Comment

                        Previous template Next
                        Working...