Re: Index on unique/primary key

2002-05-29 Thread Victoria Reznichenko
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

2002-05-29 Thread Dicky Wahyu Purnomo
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