automatic index for not null unique columns?

2001-11-12 Thread Steve Fink
I couldn't find an explanation of this behavior in the docs. When I use the following CREATE command: CREATE TABLE D6 (id int(10) not null unique); it appears to automatically create an index for me: mysql SHOW INDEX FROM D6; +---++--+--+-+... |

Re: automatic index for not null unique columns?

2001-11-12 Thread Steve Fink
Quoting Steve Fink ([EMAIL PROTECTED]): I couldn't find an explanation of this behavior in the docs. When I use the following CREATE command: CREATE TABLE D6 (id int(10) not null unique); it appears to automatically create an index for me: Argh! Never mind. Learn something new every day

Re: automatic index for not null unique columns?

2001-11-12 Thread Arjen G. Lentz
Hi Steve, - Original Message - From: Steve Fink [EMAIL PROTECTED] I couldn't find an explanation of this behavior in the docs. When I use the following CREATE command: CREATE TABLE D6 (id int(10) not null unique); it appears to automatically create an index for me: Argh!