List:General Discussion« Previous MessageNext Message »
From:jkraai Date:May 19 1999 3:15pm
Subject:Re: Minor SQL Question
View as plain text  
Once again, the best support on the planet!

Thanks, Paul.

--jim

-----Original Message-----
From: Paul DuBois <paul@stripped>

>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_functi
ons
>
>--
>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