Re: ????: RE: comparison operations in IN subquery

2008-05-14 Thread Dan Nelson
In the last episode (May 15), raid fifa said: > Jerry Schwartz <[EMAIL PROTECTED]> : > > look at the following test case: > > > > mysql> create table temp1( id int)ENGINE=innodb; > >Query OK, 0 rows affected (0.18 sec) > > > >mysql> create table temp2( tid varchar(10))ENGINE=innodb; > >Query OK

RE: comparison operations in IN subquery

2008-05-14 Thread Jerry Schwartz
>Hi guys, > > look at the following test case: > > mysql> create table temp1( id int)ENGINE=innodb; >Query OK, 0 rows affected (0.18 sec) > >mysql> create table temp2( tid varchar(10))ENGINE=innodb; >Query OK, 0 rows affected (0.07 sec) > >mysql> insert into temp1 values(1); >Query OK, 1 row affe

Re: comparison operations in IN subquery

2008-05-14 Thread Dan Nelson
In the last episode (May 14), xian liu said: > mysql> select * from temp1; > +--+ > | id | > +--+ > |1 | > |2 | > |3 | > |4 | > +--+ > 4 rows in set (0.01 sec) > > mysql> select * from temp2; > +---+ > | tid | > +---+ > | 2,3,4 | > +---+ > 1 row in