Re: SELECT vs SET for creating variables

Bill, >SELECT @neededStep := 10; >SELECT @startOfCenter := 7; >SELECT @returnData := >IF(@neededStep <= @startOfCenter, > CONCAT(@neededStep, ' <= ', @startOfCenter), > CONCAT(@neededStep, ' > ', @startOfCenter) >); >In the above example @returnData ends up being '10 <= 7', but when

Re: SELECT vs SET for creating variables

Bill Dodson wrote: I am using version 4.0.12-nt on a Windows 2000 machine. I have 4.1.11. I have noticed some difference in the way SET and SELECT create variables. The following statements do not work the way I would expect. SELECT @neededStep := 10; SELECT @startOfCenter := 7; SELECT @r

SELECT vs SET for creating variables

I am using version 4.0.12-nt on a Windows 2000 machine. I have noticed some difference in the way SET and SELECT create variables. The following statements do not work the way I would expect. SELECT @neededStep := 10; SELECT @startOfCenter := 7; SELECT @returnData := IF(@neededStep <= @startO