Difference between keys and indexes

[Randell D.]

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

Much appreciated,
randelld

[@(none).adelphia.net]

Randell D. wrote:

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

Much appreciated,
randelld

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

[Randell D.]

"@(none).adelphia.net" <""jgreenaw\"@(none).adelphia.net"> wrote in message
news:3f*********************@newscene.com...

Randell D. wrote:

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

Much appreciated,
randelld

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

Luvely Juvely...

Thanx

[swdev1]

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:ex********@efgroup.net
mySql / VFP / MS-SQL
"Randell D." <yo**************************@yahoo.com> wrote in message
news:TH***********************@news2.calgary.shaw. ca...

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

Much appreciated,
randelld

[swdev1]

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:ex********@efgroup.net
mySql / VFP / MS-SQL
"Randell D." <yo**************************@yahoo.com> wrote in message
news:TH***********************@news2.calgary.shaw. ca...

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

Much appreciated,
randelld

[swdev1]

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:ex********@efgroup.net
mySql / VFP / MS-SQL
"Randell D." <yo**************************@yahoo.com> wrote in message
news:TH***********************@news2.calgary.shaw. ca...

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

Much appreciated,
randelld