It's indexed..
if you create a table like so:
create table planner(
id integer not null auto_increment,
tstamp timestamp,
uid integer not null,
db_id integer not null,
vendor bool not null default 0,
list bool not null default 0,
companylist bool not null default 0,
article bool not null default 0,
plan bool not null default 0,
accent bool not null default 0,
key planner_key (id)
);
mysql> show keys from planner;
+---------+------------+-------------+--------------+-------------+---------
--+-------------+----------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part |
+---------+------------+-------------+--------------+-------------+---------
--+-------------+----------+
| planner | 1 | planner_key | 1 | id | A
| NULL | NULL |
+---------+------------+-------------+--------------+-------------+---------
--+-------------+----------+
-----Original Message-----
From: Gorantla, Aruna [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 9:47 AM
To: '[EMAIL PROTECTED]'
Cc: Gorantla, Aruna
Subject: MySQL Index
Hi,
I would like to know whether the primary keys are automatically indexed in
MySQL or do you have to index them explicitly?
Thanks in advance,
Aruna.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
