MySQL column names and aliases

Posted by user329820 on Stack Overflow See other posts from Stack Overflow or by user329820
Published on 2010-04-30T15:57:15Z Indexed on 2010/04/30 16:17 UTC
Read the original article Hit count: 115

Filed under:

hi, I have read that after select we use column-names but I have found a statement that was like this:

SELECT 'A' FROM T WHERE A = NULL;

would you lease help me? thanks (A is a column- name here?) my DBMS is MySQL

EDITED : the exact question is this that: Will the above statement produce a row (select all that apply)? Notice that ANSI_NULLS is OFF.

I want to know that the above statement will work? because some of you said that we should write IS NULL instead of =null

© Stack Overflow or respective owner

Related posts about mysql