Re: Selecting unique values:K@N@!:

2003-07-31 Thread Egor Egorov
Alec Smith <[EMAIL PROTECTED]> wrote: > I have two tables as below: > > CREATE TABLE domain_types ( > type_id INT(4) NOT NULL AUTO_INCREMENT, > name VARCHAR(10) UNIQUE NOT NULL, > description VARCHAR(75), > PRIMARY KEY(type_id) > ) TYPE=INNODB COMMENT="Types of domains we store"; > > CREATE T

Selecting unique values:K@N@!:

2003-07-28 Thread Alec Smith
I have two tables as below: CREATE TABLE domain_types ( type_id INT(4) NOT NULL AUTO_INCREMENT, name VARCHAR(10) UNIQUE NOT NULL, description VARCHAR(75), PRIMARY KEY(type_id) ) TYPE=INNODB COMMENT="Types of domains we store"; CREATE TABLE domains ( domain_id INT(6) NOT NULL AUTO_INCREM