Re: MUL when describe table

2006-04-10 Thread Shawn Green
--- Scott Purcell <[EMAIL PROTECTED]> wrote: > Hello, > > > > When I do a table describe, I see a MUL on a column I have marked as > a > foreign-key. I tried searching for MUL within the docs, but do not > see a > concise explanation of what that is? > > > > Anyone? > > > > Thanks, >

Re: MUL

2001-04-26 Thread Welcome
it means it allow multiple records have same value in a table. i.e. It allow index to contain duplicates. it really is not a key. it is a kind of index instead. if you have a table using a primary key say table_a, try to use "SHOW INDEX FROM table_a", then "SHOW INDEX FROM ACCOUNTING". you can s