AW: different between index and key when create table

2003-09-03 Thread Morten Gulbrandsen
I'm trying to express. = -Ursprüngliche 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 cr

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 cre

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.

different between index and key when create table

2003-09-02 Thread Vivian Wang
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.