Fwd: different between index and key when create table

2003-09-02 Thread Vivian Wang 
mysql:
Can anyone tell me what is different between index and key when creating 
table?
like this situation:

create table info ( fname char(9), lname char (15), address char(30), 
index(lname));
or
create table info ( fname char(9), lname char(15), address char(30), 
key(lname));

Thanks.

Re: Fwd: different between index and key when create table

2003-09-02 Thread vze2spjf 

 
 From: Vivian Wang [EMAIL PROTECTED]
 Date: 2003/09/02 Tue PM 02:16:26 CDT
 To: [EMAIL PROTECTED]
 Subject: Fwd: different between index and key when create table
 
 mysql:
 
 Can anyone tell me what is different between index and key when creating 
 table?
 like this situation:
 
 create table info ( fname char(9), lname char (15), address char(30), 
 index(lname));
 or
 create table info ( fname char(9), lname char(15), address char(30), 
 key(lname));
 
 
 Thanks.

From the online manual:
KEY is normally a synonym for INDEX. From version 4.1, the key attribute PRIMARY KEY 
may also be specified as just KEY. This was implemented 
for compatibility with other databases.

See:
http://www.mysql.com/doc/en/CREATE_TABLE.html

Note that in DB *theory*, however, keys and indexes are not the same.

sjfromm



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]