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:
- different between index and key when create table Vivian Wang
- AW: different between index and key when create ta... Morten Gulbrandsen
- Re: Fwd: different between index and key when crea... Vivian Wang
- Re: Fwd: different between index and key when crea... vze2spjf