2010-03-19から1日間の記事一覧
MySQLってこんなの書けるんだなーって再認識。 mysql> set @1 = 0; Query OK, 0 rows affected (0.00 sec)mysql> select 1 as k from dual where if( @1, 1, 0 ); Empty set (0.00 sec)mysql> set @1 = 1; Query OK, 0 rows affected (0.00 sec)mysql> selec…
MySQLってこんなの書けるんだなーって再認識。 mysql> set @1 = 0; Query OK, 0 rows affected (0.00 sec)mysql> select 1 as k from dual where if( @1, 1, 0 ); Empty set (0.00 sec)mysql> set @1 = 1; Query OK, 0 rows affected (0.00 sec)mysql> selec…