Re: String arithmetic?

2005-08-02 Thread Jonathan Mangin
I see these really need to be int or time types. Is there no way they can default to NULL or blank? Hi, I think I'd like to store these values as strings instead of [?]int or time types. mysql> select '3' - '1'; +---+ | '3' - '1' | +---+ | 2 | +---+ 1 row in se

String arithmetic?

2005-08-02 Thread Jonathan Mangin
Hi, I think I'd like to store these values as strings instead of [?]int or time types. Is this string arithmetic? Can/should I do this? (I see the second one won't work without single-quotes.) mysql> select '3' - '1'; +---+ | '3' - '1&#x