TalkPHP - View Single Post

Wildhoney · 06-25-2008, 11:06 PM

None as far as I can see. I thought maybe MySQL wouldn't be able to perform mathematical equations on numbers which guise themselves as strings, but it appears I am wrong, as both of these work correctly:

sql Code:

UPDATE myTable SET myCount = myCount + "2"
SELECT "1" + "10"

06-25-2008, 11:06 PM	#7 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 1,579 Thanks: 72	None as far as I can see. I thought maybe MySQL wouldn't be able to perform mathematical equations on numbers which guise themselves as strings, but it appears I am wrong, as both of these work correctly: sql Code: UPDATE myTable SET myCount = myCount + "2" SELECT "1" + "10" __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.