Re: Index on unique/primary key

ritu, Wednesday, May 29, 2002, 1:24:36 PM, you wrote: rs> specifying a column as unique or primary in MySQL rs> creates indices automatically or do we need to do it rs> explicitly using INDEX(unique/primary_colname) in rs> CREATE TABLE command of MySQL?? PRIMARY and UNIQUE are indexes. Look at:

Re: Index on unique/primary key

On Wed, 29 May 2002 11:24:36 +0100 (BST) ritu singla <[EMAIL PROTECTED]> wrote: > Hello! > > specifying a column as unique or primary in MySQL > creates indices automatically or do we need to do it > explicitly using INDEX(unique/primary_colname) in > CREATE TABLE command of MySQL?? yes, you ha

Index on unique/primary key

Hello! specifying a column as unique or primary in MySQL creates indices automatically or do we need to do it explicitly using INDEX(unique/primary_colname) in CREATE TABLE command of MySQL?? Thanx in advance.. Ritu Singla > > __