MySQL Foreign Keys and Indexes

[dstrange]

Hi, I'm kinda new to this so please be patient. I'm using MySQL Query Browser to setup some Foreign Keys and Indexes but I keep getting the dreaded 1452 error.

What is the general rule of thumb for what should come first? Foreign Keys or Indexes?
Also is it bad practice to have the same columns for both indexes and foreign keys?

Thanks in advance.

 

[r937]

the general rule is that your foreign key has to have an index

in version X (not sure which level, you could look it up in da manual), the index is "silently" created if you forget to declare it explicitly

no, it most certainly is not bad practice to have an index on a foreign key -- in fact, it is bad practice not to

r937.com | rudy.ca