Knowledge Walls
John Peter
Pune, Maharashtra, India
Blob in select query result in Mysql Indeep of MySQL
3052 Views
Mixed datatype in Mysql Select Query returns BLOB
SELECT IF (1,1,"2")
-- returns blob

SELECT IF (1,"1",2)
-- returns blob

SELECT IF(1,"1","2")
-- returns string

SELECT IF(1,1,2)
-- returns int
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details