Re: Select record by ID

> January 28, 2007 6:20 pm, Larry Garfield wrote: > On Sunday 28 January 2007 5:54 pm, Francisco M. Marzoa Alonso wrote: >> On dom, 2007-01-28 at 18:51 -0500, nitrox . wrote: >> > I took the quotes off. I thought that quotes around numbers was >> wrong >> > also. >> >> Quotes are no necessary around numeric values, but they aren't wrong >> neither, simply optional. > > Actually, I believe they are wrong in some database engines but not > others. > MySQL doesn't care. Some others do. Yes, it sucks. :-( I believe it is now possible to *make* MySQL care by putting it into "strict" mode when you start it... MySQL is the *only* db engine that lets you get away with [bleep] like apostrophes around numbers. I think strict mode also stops MySQL from the annoying habit of silently converting inadmissable date/time to '0000-00-00' [grrrr] It may even be possible to turn on strict mode with a query, and not just from launch... http://dev.mysql.com/ would tell you more about this. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So?