CREATE TABLE, NOT NULL fields, and empty strings

2003-02-07 Thread Doug Beyer
I attempted to search various places for my answer but with no luck. So I'm posting here. I create the following table: create table t1 ( id varchar(5) not null, name varchar(5) not null ); I insert the following row: insert into t1 ( id ) values ( "1234" ); I do the following selects: s

Confirmation of SELECT...IN syntax

2003-01-15 Thread Doug Beyer
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct? Example: SELECT t1.* FROM table1 t1 WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) ) Doug Beyer SAS Research and Development 503-617-7103 (Portland) [EMAIL PROTECTED] SAS... The Power to