8 Feb
2012
8 Feb
'12
6:54 p.m.
When creating a view in phpmyadmin on yahoo business I need to know the corrct syntax to
return text. Below are two examples of an If statement and a case statement that return an
Integer. Both of these views work correctly. There are also three examples of an If
statement to return text and three examples of case statements to return text. None of
these six examples work correctly even when using using single quotes, double qoutes or no
quotes at all. Please review all of the below examples and let me know what is happening
that the select statement changes.
SELECT If(Month(Now())=2,555,999)
works correctly
SELECT case Month(now()) when 2 then 555 else 999 end
works correctly
SELECT If(Month(Now())=2,'Feb','Oth')
changes the select statement to:
SELECT If(Month(Now())=2,\'Feb\',\'Oth\')
and gives error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near
'\'Feb\',\'Oth\')' at line 5
SELECT If(Month(Now())=2,"Feb","Oth")
changes the select statement to:
SELECT If(Month(Now())=2,\"Feb\",\"Oth\")
and gives error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near
'\"Feb\",\"Oth\")' at line 5
SELECT If(Month(Now())=2,Feb,Oth)
gives below error:
#1054 - Unknown column 'Feb' in 'field list'
SELECT case Month(now()) when 2 then 'Feb' else 'Other' end
changes the select statement to:
SELECT case Month(now()) when 2 then \'Feb\' else \'Other\' end
and gives error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '\'Feb\' else
\'Other\' end' at line 5
SELECT case Month(now()) when 2 then "Feb" else "Other" end
changes the select statement to:
SELECT case Month(now()) when 2 then \"Feb\" else \"Other\" end
and gives below error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '\"Feb\" else
\"Other\" end' at line 5
SELECT case Month(now()) when 2 then Feb else Other end
gives below error:
#1054 - Unknown column 'Feb' in 'field list'