List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 19 1999 2:54pm
Subject:Re: Minor SQL Question
View as plain text  
At 9:37 AM -0500 5/19/99, jkraai@stripped wrote:
>mysql> SELECT 0='', 1='';
>+------+------+
>| 0='' | 1='' |
>+------+------+
>|    1 |    0 |
>+------+------+
>
>Is this SQL or MySQL behavior?
>
>Anyone know the rationale behind it?


MySQL tries to perform type conversion whenever it can, rather than just
give you an error.

What results were you expecting?


MySQL's comparison rules are listed at:

http://www.mysql.com/Manual_chapter/manual_Reference.html#Comparison_functions

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Minor SQL Questionjkraai19 May
  • Re: Minor SQL QuestionPaul DuBois19 May
Re: Minor SQL Questionjkraai19 May