Nachricht-
Von: Vivian Wang [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 2. September 2003 20:45
An: [EMAIL PROTECTED]
Betreff: different between index and key when create table
Can anyone tell me what is different between index and key when creating
table?
like this situation:
create table info
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.
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: 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