Skip navigation links

MySQL Forums :: InnoDB :: MySQL 5.5.8 - Configuration Settings Suggestions


Advanced Search

Re: MySQL 5.5.8 - Configuration Settings Suggestions
Posted by: Aftab Khan ()
Date: July 05, 2012 02:18AM

>This construct scares me:
>IN (1, NULL)
>NULL is generally not treated as a "value" that can be compared.

This construct looks ok to me. In MySQL, 0 or NULL means false and anything else means true, here is the test case:

mysql> select 1 IN (1,NULL), 1 IN (2,NULL),  1 IN(2,3), NULL IN(2,3);
+---------------+---------------+-----------+--------------+
| 1 IN (1,NULL) | 1 IN (2,NULL) | 1 IN(2,3) | NULL IN(2,3) |
+---------------+---------------+-----------+--------------+
|             1 |          NULL |         0 |         NULL |
+---------------+---------------+-----------+--------------+
1 row in set (0.00 sec)

can you please explain what's your concern?



Edited 2 time(s). Last edit at 07/05/2012 03:37AM by Aftab Khan.

Options: ReplyQuote


Subject Views Written By Posted
MySQL 5.5.8 - Configuration Settings Suggestions 1321 Samir Dash 06/19/2012 03:53AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 707 Aftab Khan 06/25/2012 05:44AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 1042 Samir Dash 06/25/2012 11:00AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 749 Samir Dash 06/25/2012 11:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 603 Samir Dash 06/25/2012 11:03AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 769 Aftab Khan 06/25/2012 12:23PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 666 Samir Dash 06/26/2012 02:20AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 713 Aftab Khan 06/26/2012 03:18AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 995 Samir Dash 06/26/2012 03:36AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 698 Aftab Khan 06/26/2012 05:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 665 Samir Dash 06/28/2012 02:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 892 Aftab Khan 06/29/2012 12:59AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 660 Samir Dash 06/29/2012 01:12AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 672 Samir Dash 06/29/2012 02:14AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 824 Aftab Khan 06/29/2012 02:46AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 659 Samir Dash 06/29/2012 03:27AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 686 Aftab Khan 06/29/2012 07:43AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 701 Samir Dash 06/29/2012 07:22PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 718 Rick James 06/29/2012 06:14PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 695 Samir Dash 06/29/2012 07:39PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 723 Aftab Khan 06/30/2012 01:27AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 626 Samir Dash 06/30/2012 01:48AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 629 Aftab Khan 06/30/2012 01:53AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 604 Samir Dash 06/30/2012 02:20AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 600 Aftab Khan 06/30/2012 02:39AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 687 Samir Dash 06/30/2012 04:35AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 670 Aftab Khan 06/30/2012 06:02AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 709 Samir Dash 07/03/2012 09:57AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 656 Rick James 07/04/2012 06:39AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 654 Aftab Khan 07/05/2012 02:18AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 638 Peter Brawley 07/05/2012 11:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 654 Aftab Khan 07/05/2012 12:53PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 641 Rick James 07/06/2012 03:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.