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 set (0.00 sec)

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 affected (0.07

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, 0 rows affected