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: 135
mysql
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