(primary key == index) ?

[erehwon]

when I create a table, I always make the first column my unique-id, and make
this primary key auto-increment.
Does this mean that the table will be indexed by mysql on this key - or do I
need to explicitly do this too?

e.g.

create table note
(
note_id INTEGER(9) AUTO_INCREMENT PRIMARY KEY,
mytext varchar(255)
);

So do I need to add something to get mysql indexing on the primary key?

many thanks,
JJ

[Dave Roe]

erehwon wrote:

when I create a table, I always make the first column my unique-id, and make
this primary key auto-increment.
Does this mean that the table will be indexed by mysql on this key - or do I
need to explicitly do this too?

interesting question. I wanted to know the answer to this too, so I
looked it up in the documentation at www.mysql.com. the answer is "yes"
- the table is indexed. this can be verified by running 'SHOW INDEX FROM
<table_name>' using the mysql client.

/dave

[Dave Roe]

erehwon wrote:

when I create a table, I always make the first column my unique-id, and make
this primary key auto-increment.
Does this mean that the table will be indexed by mysql on this key - or do I
need to explicitly do this too?

interesting question. I wanted to know the answer to this too, so I
looked it up in the documentation at www.mysql.com. the answer is "yes"
- the table is indexed. this can be verified by running 'SHOW INDEX FROM
<table_name>' using the mysql client.

/dave

[erehwon]

great :o) & thanks!

JJ

"Dave Roe" <da******@email.com> wrote in message
news:DH*******************@newsread2.news.pas.eart hlink.net...

erehwon wrote:

when I create a table, I always make the first column my unique-id, and make this primary key auto-increment.
Does this mean that the table will be indexed by mysql on this key - or do I need to explicitly do this too?

interesting question. I wanted to know the answer to this too, so I
looked it up in the documentation at www.mysql.com. the answer is "yes"
- the table is indexed. this can be verified by running 'SHOW INDEX FROM
<table_name>' using the mysql client.

/dave

[erehwon]

great :o) & thanks!

JJ

"Dave Roe" <da******@email.com> wrote in message
news:DH*******************@newsread2.news.pas.eart hlink.net...

erehwon wrote:

when I create a table, I always make the first column my unique-id, and make this primary key auto-increment.
Does this mean that the table will be indexed by mysql on this key - or do I need to explicitly do this too?

interesting question. I wanted to know the answer to this too, so I
looked it up in the documentation at www.mysql.com. the answer is "yes"
- the table is indexed. this can be verified by running 'SHOW INDEX FROM
<table_name>' using the mysql client.

/dave